This discussion is archived
1 2 Previous Next 24 Replies Latest reply: Oct 7, 2010 12:42 PM by Jonathan Lewis RSS

high consistent read during parse call | tkprof output

537700 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points