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.
Bookmarks