ELAPSED_SECONDS TIME_REMAINING SQL_ID SOFAR TOTALWORK
--------------- -------------- ------------- ---------- ----------
750 0 90ccdwpdtaq81 322615 322615
下面是更改为NSET LOOP后相关资源消耗
SID NAME VALUE
---------- ---------------------------------------------------------------- ----------
20 session logical reads 5110391
20 physical read total IO requests 218114
20 physical read total multi block requests 2520
20 physical read total bytes 4402323456
20 logical read bytes from cache 4186432307
20 physical reads 537393
20 physical reads cache 537393
20 physical read IO requests 218114
20 physical read bytes 4402323456
20 physical reads cache prefetch 319289
20 redo entries 816088
20 redo size 396696100
20 redo buffer allocation retries 1
20 redo log space requests 2
20 redo log space wait time 5
20 redo ordering marks 33766
20 redo subscn max counts 33781
20 redo synch time (usec) 5
20 redo synch writes 2
20 Batched IO vector read count 8
SID NAME VALUE
---------- ---------------------------------------------------------------- ----------
20 undo change vector size 263713896
20 data blocks consistent reads - undo records applied 206356
20 no work - consistent read gets 404311
20 cleanouts only - consistent read gets 1
20 cleanouts and rollbacks - consistent read gets 103178
20 IMU undo allocation size 7624
20 sorts (memory) 17
20 sorts (rows) 68