NAME VALUE ---------------------------------------------------------------- ---------- logons cumulative 4117 logons current 14 opened cursors cumulative 460086 opened cursors current 38 user commits 2876 user rollbacks 364 user calls 338468 recursive calls 2099221 recursive cpu usage 23619 session logical reads 1.0534E+10 session stored procedure space 0 NAME VALUE ---------------------------------------------------------------- ---------- CPU used when call started 3930549 CPU used by this session 3930549 session connect time 2.2302E+12 process last non-idle time 2.2302E+12 session uga memory 50145344 session uga memory max 2527113512 messages sent 922892 messages received 922893 background timeouts 731069 session pga memory 13561592 session pga memory max 18542328 NAME VALUE ---------------------------------------------------------------- ---------- enqueue timeouts 0 enqueue waits 0 enqueue deadlocks 0 enqueue requests 3204716 enqueue conversions 1059 enqueue releases 3204694 global lock sync gets 0 global lock async gets 0 global lock get time 0 global lock sync converts 0 global lock async converts 0 NAME VALUE ---------------------------------------------------------------- ---------- global lock convert time 0 global lock releases 0 total file opens 0 opens requiring cache replacement 0 opens of replaced files 0 gcs messages sent 0 ges messages sent 0 db block gets 3848000 consistent gets 1.0530E+10 physical reads 3388930 db block changes 5449744 NAME VALUE ---------------------------------------------------------------- ---------- consistent changes 955359 recovery blocks read 1563 physical writes 93942 physical writes non checkpoint 83838 summed dirty queue length 0 DBWR checkpoint buffers written 26692 DBWR transaction table writes 3223 DBWR undo block writes 19025 DBWR revisited being-written buffer 0 DBWR make free requests 252 DBWR free buffers found 91399 NAME VALUE ---------------------------------------------------------------- ---------- DBWR lru scans 242 DBWR summed scan depth 91480 DBWR buffers scanned 91480 DBWR checkpoints 7 DBWR cross instance writes 0 DBWR fusion writes 0 remote instance undo block writes 0 remote instance undo header writes 0 prefetch clients - keep 0 prefetch clients - recycle 0 prefetch clients - default 0 NAME VALUE ---------------------------------------------------------------- ---------- prefetch clients - 2k 0 prefetch clients - 4k 0 prefetch clients - 8k 0 prefetch clients - 16k 0 prefetch clients - 32k 0 change write time 2564 redo synch writes 1431 redo synch time 59 exchange deadlocks 0 free buffer requested 3838109 dirty buffers inspected 326 NAME VALUE ---------------------------------------------------------------- ---------- pinned buffers inspected 98 hot buffers moved to head of LRU 755622 free buffer inspected 827 commit cleanout failures: write disabled 0 commit cleanout failures: block lost 0 commit cleanout failures: cannot pin 0 commit cleanout failures: hot backup in progress 0 commit cleanout failures: buffer being written 0 commit cleanout failures: callback failure 0 commit cleanouts 1353322 commit cleanouts successfully completed 1353322 NAME VALUE ---------------------------------------------------------------- ---------- recovery array reads 14 recovery array read time 171 CR blocks created 20452 current blocks converted for CR 0 switch current to new buffer 447241 write clones created in foreground 0 write clones created in background 0 prefetched blocks 1828275 prefetched blocks aged out before use 792 physical reads direct 26658 physical writes direct 66530 NAME VALUE ---------------------------------------------------------------- ---------- physical reads direct (lob) 7554 physical writes direct (lob) 49 cold recycle reads 0 consistent gets - examination 7644692174 shared hash latch upgrades - no wait 26439827 shared hash latch upgrades - wait 2439 calls to kcmgcs 2208 calls to kcmgrs 0 calls to kcmgas 1389548 next scns gotten without going to GES 0 Unnecesary process cleanup for SCN batching 0 NAME VALUE ---------------------------------------------------------------- ---------- calls to get snapshot scn: kcmgss 14862026 kcmgss waited for batching 0 kcmgss read scn without going to GES 0 kcmccs called get current scn 0 redo entries 2736496 redo size 588868680 redo buffer allocation retries 12 redo wastage 97609112 redo writer latching time 0 redo writes 904958 redo blocks written 1384057 NAME VALUE ---------------------------------------------------------------- ---------- redo write time 1322 redo log space requests 12 redo log space wait time 142 redo log switch interrupts 0 redo ordering marks 0 global cache gets 0 global cache get time 0 global cache converts 0 global cache convert time 0 global cache cr blocks received 0 global cache cr block receive time 0 NAME VALUE ---------------------------------------------------------------- ---------- global cache current blocks received 0 global cache current block receive time 0 global cache cr blocks served 0 global cache cr block build time 0 global cache cr block flush time 0 global cache cr block send time 0 global cache current blocks served 0 global cache current block pin time 0 global cache current block flush time 0 global cache current block send time 0 global cache freelist waits 0 NAME VALUE ---------------------------------------------------------------- ---------- global cache defers 0 global cache convert timeouts 0 global cache blocks lost 0 global cache claim blocks lost 0 global cache blocks corrupt 0 global cache prepare failures 0 global cache skip prepare failures 0 total number of slots 0 instance recovery database freeze count 0 background checkpoints started 6 background checkpoints completed 6 NAME VALUE ---------------------------------------------------------------- ---------- number of map operations 0 number of map misses 0 serializable aborts 0 transaction lock foreground requests 0 transaction lock foreground wait time 0 transaction lock background gets 0 transaction lock background get time 0 transaction tables consistent reads - undo records applied 0 transaction tables consistent read rollbacks 0 data blocks consistent reads - undo records applied 954893 no work - consistent read gets 2857915907 NAME VALUE ---------------------------------------------------------------- ---------- cleanouts only - consistent read gets 6 rollbacks only - consistent read gets 101637 cleanouts and rollbacks - consistent read gets 67 RowCR attempts 0 RowCR hits 0 RowCR - row contention 0 rollback changes - undo records applied 116 transaction rollbacks 54 immediate (CURRENT) block cleanout applications 1571 immediate (CR) block cleanout applications 73 deferred (CURRENT) block cleanout applications 841960 NAME VALUE ---------------------------------------------------------------- ---------- commit txn count during cleanout 31 active txn count during cleanout 110 cleanout - number of ktugct calls 131 immediate CR cleanouts (index blocks) 0 deferred CUR cleanouts (index blocks) 0 Commit SCN cached 0 Cached Commit SCN referenced 0 number of auto extends on undo tablespace 0 number of drop segment calls under space pressure 0 total number of undo segments dropped 0 table scans (short tables) 595191 NAME VALUE ---------------------------------------------------------------- ---------- table scans (long tables) 33 table scans (rowid ranges) 0 table scans (cache partitions) 0 table scans (direct read) 0 table scan rows gotten 105178606 table scan blocks gotten 3017399 table fetch by rowid 7621450219 table fetch continued row 880 cluster key scans 657390 cluster key scan block gets 1379248 rows fetched via callback 3747946772 NAME VALUE ---------------------------------------------------------------- ---------- leaf node splits 6 leaf node 90-10 splits 0 branch node splits 0 native hash arithmetic execute 0 native hash arithmetic fail 0 index fast full scans (full) 884 index fast full scans (rowid ranges) 0 index fast full scans (direct read) 0 index fetch by key 3774162337 index scans kdiixs1 26110402 session cursor cache hits 0 NAME VALUE ---------------------------------------------------------------- ---------- session cursor cache count 0 cursor authentications 1223 queries parallelized 0 DML statements parallelized 0 DDL statements parallelized 0 DFO trees parallelized 0 Parallel operations not downgraded 0 Parallel operations downgraded to serial 0 Parallel operations downgraded 75 to 99 pct 0 Parallel operations downgraded 50 to 75 pct 0 Parallel operations downgraded 25 to 50 pct 0 NAME VALUE ---------------------------------------------------------------- ---------- Parallel operations downgraded 1 to 25 pct 0 PX local messages sent 0 PX local messages recv'd 0 PX remote messages sent 0 PX remote messages recv'd 0 buffer is pinned count 8711722966 buffer is not pinned count 1.0334E+10 no buffer to keep pinned count 1 table lookup prefetch client count 0 workarea memory allocated 0 workarea executions - optimal 1946097 NAME VALUE ---------------------------------------------------------------- ---------- workarea executions - onepass 0 workarea executions - multipass 0 parse time cpu 4272 parse time elapsed 5477 parse count (total) 498445 parse count (hard) 2612 parse count (failures) 270 execute count 1032972 bytes sent via SQL*Net to client 132319066 bytes received via SQL*Net from client 53566865 SQL*Net roundtrips to/from client 325424 NAME VALUE ---------------------------------------------------------------- ---------- bytes sent via SQL*Net to dblink 63661 bytes received via SQL*Net from dblink 93046 SQL*Net roundtrips to/from dblink 384 sorts (memory) 2394756 sorts (disk) 6 sorts (rows) 59246302 OTC commit optimization attempts 0 OTC commit optimization hits 0 OTC commit optimization failure - setup 0 251 rows selected. SQL> spool off