+-+-+ AppsDBA Event 10046 Interval Resource Profiler +-+-+ Copyright (c) 2004, AppsDBA Consulting. All Rights Reserved. +-+-+ Version 1.1, 02/19/2004 Processing trace file: 'orcl_ora_22867.trc' Run date: Fri Feb 20 05:11:11 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:11:18 2004