Hi,
SELECT N_ORIGIN,SUB_ACC_ID,STAT_DATE,TYPE,PAGE_TOT,PAGE_NO,OP_BAL,CL_BAL
FROM O_950P WHERE N_ORIGIN = :P02576 AND SUB_ACC_ID = :P02579 AND
STAT_DATE >= PRO4_TO_ORA_DATE (:P02599 ) AND TYPE = :P02863
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 9 0.00 0.00 0 0 4 0
Execute 9 0.02 0.01 0 0 0 0
Fetch 1379482 158.32 150.61 0 2759085 0 1379473
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1379500 158.34 150.63 0 2759085 4 1379473
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Parsing user id: 13074
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 1379492 0.00 2.49
SQL*Net message from client 1379491 0.39 1042.23
Here the CPU time(158.34) is more than the elapsed time (150.63) ?.How could this be ?
Documentation says..
CPU
| Total CPU time in seconds for all parse, execute, or fetch calls for the statement. This value is zero (0) if TIMED_STATISTICS is not turned on. |
ELAPSED
| Total elapsed time in seconds for all parse, execute, or fetch calls for the statement. This value is zero (0) if TIMED_STATISTICS is not turned on. |
Could you please help me in understand who elapsed time can be greater than CPU time ?