Analysis of trace file
SravpremJun 14 2011 — edited Jun 15 2011Hi all
I created one trace file. I want analysis that but i am not getting meaning of the keywords. Could any one explain the below details? If possibe please paste link where we get these details to read.
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 4.24 0 0 0 0
Execute 208 1000.00 710.19 0 0 0 0
Fetch 208 8000.00 13859.22 206 45968 0 2288
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 417 9000.00 14573.65 206 45968 0 2288
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer goal: ALL_ROWS
Parsing user id: 41
Thanks