-
Difference between consistent gets of autotrace and query column of tkprof output
What is the difference between consistent gets value from autotrace and query+current column value of tkprof output? I did a session tracing using dbms_system and also autotrace traceonly exp stat and executed a query. Autotrace output showed 110 consistent gets, but tkprof output of the same session showed 20 in query and 10 in current columns. Is this expected behaviour? All I am trying is to find the logical reads of the query. Which one should I do, autotrace or dbms_system?
Thanks.
-
tkprof never lies, autotrace can becuase it is a guess
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|