How to understand trace result
- From: "Eriovaldo Andrietta" <ecandrietta@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 10 Jan 2009 12:21:01 -0200
Hi friends
I am getting some trace files to analyze and I would like to understande
what means each number below.
Could someone give me some explanation.
These numbers are result of getting session trace for around 5 minutes only.
Regards
Eriovaldo
********************************************************************************
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current
rows
------- ------ -------- ---------- ---------- ---------- ----------
----------
Parse 0 0.00 0.00 0 0
0 0
Execute 0 0.00 0.00 0 0
0 0
Fetch 0 0.00 0.00 0 0
0 0
------- ------ -------- ---------- ---------- ---------- ----------
----------
total 0 0.00 0.00 0 0
0 0
Misses in library cache during parse: 0
OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS
call count cpu elapsed disk query current
rows
------- ------ -------- ---------- ---------- ---------- ----------
----------
Parse 280247 7.17 6.92 0 736
6 0
Execute 838921 72.83 74.21 272 79225 10914
10758
Fetch 841865 619.19 629.54 136 7889481 1
842533
------- ------ -------- ---------- ---------- ---------- ----------
----------
total 1961033 699.21 710.68 408 7969442 10921
853291
Misses in library cache during parse: 211
Misses in library cache during execute: 170
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total
Waited
---------------------------------------- Waited ----------
------------
db file sequential read 278 0.05
1.73
latch: library cache 15 0.00
0.00
latch: shared pool 10 0.00
0.00
undo segment extension 1 0.00
0.00
db file scattered read 10 0.02
0.09
log file sync 1 0.00
0.00
reliable message 3 0.00
0.00
rdbms ipc reply 3 0.01
0.02
enq: RO - fast object reuse 2 0.00
0.00
latch: row cache objects 1 0.00
0.00
279017 user SQL statements in session.
2835 internal SQL statements in session.
281852 SQL statements in session.
Other related posts:
