2 Replies Latest reply on Dec 5, 2016 10:13 AM by Arunkumark

    direct path read

    Arunkumark

      Hi Everyone,

       

      I've very complex query and it is running for long time.

      What I observed is ,

       

      1) It spents much on "direct path read", " direct path read temp", "direct path write temp". 

      2) Logical reads is increasing for every run of this sql.

       

      Database :12c

      Application : 12.1.3

       

      Regards,

      Arun Kumar K