buffer is not pinned count 60008 bytes received via SQL*Net from client 1239 bytes sent via SQL*Net to client 21431 calls to get snapshot scn: kcmgss 15 calls to kcmgas 2 cluster key scan block gets 120000 cluster key scans 60000 consistent gets 120167 consistent gets from cache 120167 CPU used by this session 124 CPU used when call started 123 cursor authentications 1 DB time 140 dirty buffers inspected 1184 enqueue releases 16 enqueue requests 16 execute count 6 free buffer inspected 4938 free buffer requested 4774 hot buffers moved to head of LRU 1418 index fast full scans (full) 1 messages sent 4 no work - consistent read gets 120158 opened cursors cumulative 6 OS Involuntary context switches 244 OS Maximum resident set size 45244 OS Page reclaims 11426 OS System time used 79 OS User time used 44 OS Voluntary context switches 95 parse count (hard) 2 parse count (total) 6 parse time cpu 1 parse time elapsed 1 physical read bytes 39108608 physical read IO requests 4640 physical read total bytes 39108608 physical read total IO requests 4640 physical read total multi block requests 20 physical reads 4774 physical reads cache 4774 physical reads cache prefetch 134 physical write bytes 3211264 physical write IO requests 56 physical write total bytes 3211264 physical write total IO requests 56 physical write total multi block requests 56 physical writes 392 physical writes direct 392 physical writes direct temporary tablespace 392 physical writes non checkpoint 392 recursive calls 20 recursive cpu usage 2 session logical reads 120167 session pga memory 114044 session pga memory max 2228224 session uga memory 65572 sorts (memory) 5 sorts (rows) 796 SQL*Net roundtrips to/from client 20 table fetch by rowid 4 table scan blocks gotten 20 table scan rows gotten 3000 table scans (short tables) 1 user calls 19 user I/O wait time 8 workarea executions - onepass 1 workarea executions - optimal 4