Home » RDBMS Server » Performance Tuning » tkprof Output - Unknown parameters?
tkprof Output - Unknown parameters? [message #65185] Tue, 01 June 2004 20:38 Go to next message
IA
Messages: 91
Registered: March 2004
Member
Hi Everyone,

I currently use Oracle 9i on a Solaris platform.

I have a sample tkrpof output from my database. Please see sections highlighted in bold below. I would like to know what they mean.

ie (cr=1 pr=1 pw=0 time=18104 us)

Thanks ... IA

 

select count(*)
from employee

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.25       0.26          0         50          0           0
Execute      1      0.00       0.00          0          0          0           0
Fetch        2      0.00       0.01          1          1          0           1
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        4      0.25       0.28          1         51          0           1

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 64 

Rows     Row Source Operation
-------  ---------------------------------------------------
      1  SORT AGGREGATE (cr=1 pr=1 pw=0 time=18104 us)
      3   INDEX FULL SCAN EMPLOYEE_PK (cr=1 pr=1 pw=0 time=18073 us)(object id 50647)
Re: tkprof Output - Unknown parameters? [message #65259 is a reply to message #65185] Wed, 07 July 2004 00:24 Go to previous message
Satheesh Babu.S
Messages: 35
Registered: July 2004
Member
cr ==> Consistent Read
pr ==> Physical Read
pw ==> Physical Write

Thanks and Regards,
Satheesh Babu.S
Bangalore.
Previous Topic: NOLOGGING, APPEND, PARALLEL
Next Topic: Poor performance in database while reporting and batch processing
Goto Forum:
  


Current Time: Wed Sep 23 12:21:35 CDT 2020