1 2 Previous Next 24 Replies Latest reply: Oct 7, 2010 2:42 PM by Jonathan Lewis RSS

    high consistent read during parse call | tkprof output

    PAB
      Hello all,

      Platform:- Oracle 10.2.0 on windows 32 bit

      I want your help to understand following trace file.
      If you look at this trace file there is high number of consistent read block for prase call. I want to know why Oracle go for this much of consistent read for parse call?
      select u.DISPLAY_NAME,u.PASSWORD,u.user_type 
      FROM
       USER_ACCOUNT u,STATUS s WHERE u.status_id=s.status_id and 
        Lower(u.DISPLAY_NAME) like Lower('admin') and s.STATUS_NAME='Available'
      
      
      call     count       cpu    elapsed       disk      query    current        rows
      ------- ------  -------- ---------- ---------- ---------- ----------  ----------
      Parse        4      0.85       1.07          0       3599          0           0
      Execute      4      0.00       0.00          0          0          0           0
      Fetch        4      0.01       0.05         14         36          0           4
      ------- ------  -------- ---------- ---------- ---------- ----------  ----------
      total       12      0.86       1.13         14       3635          0           4
      
      Misses in library cache during parse: 4
      Optimizer mode: ALL_ROWS
      Parsing user id: 72  
      
      Rows     Row Source Operation
      -------  ---------------------------------------------------
            1  NESTED LOOPS  (cr=9 pr=8 pw=0 time=33821 us)
            1   TABLE ACCESS BY INDEX ROWID STATUS (cr=2 pr=2 pw=0 time=21787 us)
            1    INDEX UNIQUE SCAN STATUS_CON21 (cr=1 pr=1 pw=0 time=20957 us)(object id 58618)
            1   TABLE ACCESS FULL USER_ACCOUNT (cr=7 pr=6 pw=0 time=11978 us) 
      Thanks.
        1 2 Previous Next