Q
Problem solve Get help with specific problems with your technologies, process and projects.

Help with tkprof report

My total CPU time is 214 minutes for 672 rows fetched. Under "query" I have 6830738. What does this mean?

My total CPU time is 214 minutes for 672 rows fetched. Under "query" I have 6830738. What does this mean?
The top of every tkprof report contains a legend explaining what the various statistics column headers mean. "Query" shows the number of blocks visited in query (i.e., consistent read) mode; basically, it's how many database blocks were read in the course of executing your query.

Dig Deeper on Oracle database performance problems and tuning

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close