Raw Trace Data Stat meaningsThis is a featured page

Platform: Oracle App: Tool:
DB Ver: 9.2 App Ver: Tool Ver:
Revision Date: 11-Jan-2006 Keywords: REF, REFERENCE, TRACE FILE STATS MEANING
Reference
The following is a reference table of the meaning of the statistics emitted by the Oracle Extended SQL Trace facility. Originally based onOptimizing Oracle Performance (Table 5-2 pg 85, Cary Millsap 2003).
Field Cursor ID DB Call Wait Event Description
c * Total CPU time consumed by the database call. Reported in microseconds on Oracle 9i, centiseconds on prior releases.
cr * Number of Oracle blocks obtained from the database buffer cache in consistent mode.
cu * Number of Oracle blocks obtained from the database buffer cache in current mode.
dep * * The recursive depth of the cursor.
e * Elapsed duration consumed by the database call. Reported in microseconds on Oracle 9i, centiseconds on prior releases.
ela * Elapsed duration consumed by the wait event. Reported in microseconds on Oracle 9i, centiseconds on prior releases.
hv * Statement ID.
mis * Number of misses upon the library cache.
nam * Name of the wait event.
p * Number of Oracle blocks obtained via operating system read calls.
p1,p2,p3 * Information about the wait event; varies by value of nam.
tim * * The internal Oracle time at which an event completed.
r * The number of rows returned by the call.
og * The optimizer goal in effect during the call. (1=ALL_ROWS, 2=FIRST_ROWS, 3=RULE, 4=CHOOSE)


consultium
consultium 		Latest page update: made by consultium , Oct 9 2009, 8:57 AM EDT (about this update About This Update consultium Edited by consultium

241 words added

view changes
- complete history)
Keyword tags: REF REFERENCE TRACE FILE STATS MEANING
More Info: links to this page

Threads for this page

There are no threads for this page.  Be the first to start a new thread.

Related Content

  (what's this?Related ContentThanks to keyword tags, links to related pages and threads are added to the bottom of your pages. Up to 15 links are shown, determined by matching tags and by how recently the content was updated; keeping the most current at the top. Share your feedback on Wetpaint Central.)
Analytical Functions (1) Index Of Oracle SQL Commands AUTOTRACE options and examples
Standard Utility scripts Login Script Structure of an Extended SQL Trace file
Effective MULTIBLOCK READ COUNT values used in cost calculations What IS the cost of a query and what does it mean? Oracle timing units of measure
Creating Reports