How to understand trace result
Date: Sat, 10 Jan 2009 12:21:01 -0200
Message-ID: <90b7e6bd0901100621t65e94533q7f2be706a30b1267_at_mail.gmail.com>
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 1842533
------- ------ -------- ---------- ---------- ---------- ----------
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 TotalWaited
- 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.
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jan 10 2009 - 08:21:01 CST