| tkprof Output - Unknown parameters? [message #65185] |
Tue, 01 June 2004 20:38  |
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)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
