Version 1.1, 02/19/2004
Processing trace file: 'orcl_ora_22867.trc'
Run date: Fri Feb 20 05:10:42 2004
TRACE INFORMATION
Node Name = appsdba
Instance Name = ORCL
Database Version = 9.2.0.2.0
Trace file = orcl_ora_22867.trc
Trace file lines = 14270
Distinct sessions = 1
Number of connections = 1
SESSION INFORMATION
Session SID: = 12
Session Serial#: = 1489
Connection Summary
Session start: = 03-13-2003 12:29:21.627
Interval start (t0) = 4814900616484
Interval end (t1) = 4815381057267
Interval duration = 480.440783s
SQL cursors found = 506
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
--------- LIO Blocks --------- --------- PIO Blocks ---------
Action Count Rows CPU Elapsed Total Consistent Current Total SGA PGA
------- -------- ----------- ------------ ----------- ---------- ---------- -------- ---------- ---------- --------
PARSE 11 0 0.050000 0.079453 14 14 0 1 1 0
EXEC 12 2 0.200000 0.540152 513 461 52 45 45 0
FETCH 78 1,020 10.320000 45.683574 236,589 236,584 5 13,810 13,390 420
------- -------- ----------- ------------ ----------- ---------- ---------- -------- ---------- ---------- --------
Total 101 1,022 10.570000 46.303179 237,116 237,059 57 13,856 13,436 420
OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS
--------- LIO Blocks --------- --------- PIO Blocks ---------
Action Count Rows CPU Elapsed Total Consistent Current Total SGA PGA
------- -------- ----------- ------------ ----------- ---------- ---------- -------- ---------- ---------- --------
PARSE 494 0 0.110000 0.330348 405 405 0 27 27 0
EXEC 567 9 0.090000 0.185094 69 38 31 15 15 0
FETCH 934 726 1.330000 1.456744 94,762 94,762 0 31 31 0
------- -------- ----------- ------------ ----------- ---------- ---------- -------- ---------- ---------- --------
Total 1,995 735 1.530000 1.972186 95,236 95,205 31 73 73 0
INTERVAL RATES AND WAITS (service time + wait time)
Total Event % Event Total
Event Name Time (sec) Time Events Avg Time(sec) Min Time(sec) Max Time(sec)
-------------------------------- ----------------- ------- ---------- ------------- ------------- -------------
SQL*Net message from client 434.039051 90.14 85 5.106342 0.000557 140.762792
direct path write 30.327735 6.30 207 0.146511 0.016488 0.195975
CPU Service 10.570000 2.20 2,096 0.005043 0.000000 6.800000
db file sequential read 6.550165 1.36 8,545 0.000767 0.000043 0.037470
log file sync 0.027278 0.01 3 0.009093 0.006175 0.010574
direct path read 0.015353 0.00 87 0.000176 0.000019 0.003274
SQL*Net break/reset to client 0.000304 0.00 2 0.000152 0.000131 0.000173
db file scattered read 0.000189 0.00 1 0.000189 0.000189 0.000189
SQL*Net message to client 0.000171 0.00 85 0.000002 0.000001 0.000006
unaccounted-for -1.089463 0.00
-------------------------------- ----------------- ------- ---------- ------------- ------------- -------------
Total 480.440783 100.00 11,111
End of script: Fri Feb 20 05:10:49 2004
