call count cpu
elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 20001 1.09 1.11 3151 22909 0 299999
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 20003 1.09
1.12 3151 22909 0 299999
Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 9
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
299999 299999 299999 COUNT STOPKEY (cr=22909 pr=3151 pw=0 time=1541590 us starts=1)
299999 299999 299999 TABLE ACCESS FULL ADRESSE (cr=22909 pr=3151 pw=0 time=666064 us starts=1 cost=640 size=24899917 card=299999)
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 20001 0.00 0.04
Disk file operations I/O 1 0.00 0.00
db file sequential read 1 0.00 0.00
db file scattered read 25 0.00 0.01
SQL*Net message from client 20001 16.46 215.94
********************************************************************************
Partager