SID STATISTIC# NAME VALUE
---------- ---------- ---------------------------------------------------------------- -------------------
307 58 physical read bytes 86764797952
307 39 physical read total bytes 86764797952
307 42 physical write total bytes 8617197568
307 66 physical write bytes 8617197568
307 18 session connect time 1296652871
307 19 process last non-idle time 1296652871
307 25 session pga memory 1003279648
307 26 session pga memory max 1003279648
307 20 session uga memory 966983976
307 21 session uga memory max 966983976
307 251 table scan rows gotten 273984187
307 351 sorts (rows) 132516915
307 54 physical reads 5295703
307 9 session logical reads 3520034
307 51 consistent gets from cache 3519936
307 50 consistent gets 3519936
307 180 no work - consistent read gets 3518024
307 252 table scan blocks gotten 3516499
307 93 free buffer requested 3317729
307 55 physical reads cache 3317707
307 114 physical reads cache prefetch 3165814
307 97 free buffer inspected 2533775
307 37 physical read total IO requests 2117740
307 57 physical read IO requests 2117740
307 56 physical reads direct 1977996
307 121 physical reads direct temporary tablespace 1977996
307 199 Cached Commit SCN referenced 1294402
307 332 workarea memory allocated 943529
307 123 physical writes direct temporary tablespace 525952
307 67 physical writes non checkpoint 525952
307 63 physical writes direct 525952
307 62 physical writes 525952
307 343 bytes sent via SQL*Net to client 144323
307 38 physical read total multi block requests 116503
307 17 user I/O wait time 85087
307 344 bytes received via SQL*Net from client 47542
307 13 DB time 41265
307 40 physical write total IO requests 39960
307 65 physical write IO requests 39960
307 41 physical write total multi block requests 39955
307 96 hot buffers moved to head of LRU 22744
307 337 parse time elapsed 22677
307 7 recursive calls 19718
307 134 redo size 14744
307 12 CPU used by this session 13032
307 11 CPU used when call started 12295
307 94 dirty buffers inspected 8915
307 32 enqueue releases 5173
307 30 enqueue requests 5173
307 176 undo change vector size 4336
307 328 buffer is pinned count 2998
307 116 prefetched blocks aged out before use 2654
307 253 table fetch by rowid 2021
307 329 buffer is not pinned count 1759
307 8 recursive cpu usage 1583
307 336 parse time cpu 1579
307 52 consistent gets - examination 1532
307 131 calls to get snapshot scn: kcmgss 1250