SQL*Net message from client
Hi everyone,
My platform:
Oracle9i Release 9.2.0.1.0 -- windows 2003 R2 SP2 standard edition
We are working with a third party application and a process is taking us a long time.
We have made a track with sqltrace and this is the result:
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 6212 2.17 1.91 0 0 0 0
Execute 1548579 33.82 32.52 15 6203 24541 3298
Fetch 3089298 35.78 34.92 0 42979 8 3377968
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4644089 71.78 69.36 15 49182 24549 3381266
Misses in library cache during parse: 1372
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
My platform:
Oracle9i Release 9.2.0.1.0 -- windows 2003 R2 SP2 standard edition
We are working with a third party application and a process is taking us a long time.
We have made a track with sqltrace and this is the result:
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 6212 2.17 1.91 0 0 0 0
Execute 1548579 33.82 32.52 15 6203 24541 3298
Fetch 3089298 35.78 34.92 0 42979 8 3377968
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4644089 71.78 69.36 15 49182 24549 3381266
Misses in library cache during parse: 1372
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
0