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

Finding number of logical reads in a block through tkprof output

How can I tell the number of logical reads in a particular block by looking at the tkprof output? I want to know which function/procedure in my package is being repeatedly called.

How can I tell the number of logical reads in a particular block by looking at the tkprof output? I want to know which function/procedure in my package is being repeatedly called.
Tkprof output does not show you the number of logical reads of a particular block, just the total number of logical reads associated with each SQL statement. In any event, the number of block reads has nothing to do with how often a particular procedure or function is called. You may be confusing data block reads with executions of objects in the shared pool.

If you can change the source code of your package, you can add instrumentation that increments a counter and saves it either to a package variable or a row in a log table every time the object of interest is called.

Dig Deeper on Oracle and SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

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