select name, value from v$sysstat order by name; NAME VALUE ---------------------------------------------------------------- --------- CPU used by this session 0 CPU used when call started 0 CR blocks created 0 Cached Commit SCN referenced 0 Commit SCN cached 0 DBWR buffers scanned 244 DBWR checkpoint buffers written 0 DBWR checkpoints 0 DBWR forced writes 0 DBWR free buffers found 235 DBWR lru scans 6 DBWR make free requests 6 DBWR revisited being-written buffer 0 DBWR summed scan depth 250 DBWR transaction table writes 2 DBWR undo block writes 5 DDL statements parallelized 0 DFO trees parallelized 0 DML statements parallelized 0 PX local messages recv'd 0 PX local messages sent 0 PX remote messages recv'd 0 PX remote messages sent 0 Parallel operations downgraded 1 to 25 pct 0 Parallel operations downgraded 25 to 50 pct 0 Parallel operations downgraded 50 to 75 pct 0 Parallel operations downgraded 75 to 99 pct 0 Parallel operations downgraded to serial 0 Parallel operations not downgraded 0 SQL*Net roundtrips to/from client 58 SQL*Net roundtrips to/from dblink 0 Unnecesary process cleanup for SCN batching 0 background checkpoints completed 0 background checkpoints started 0 background timeouts 224 branch node splits 0 buffer is not pinned count 25847 buffer is pinned count 14959 bytes received via SQL*Net from client 5014 bytes received via SQL*Net from dblink 0 bytes sent via SQL*Net to client 17865 bytes sent via SQL*Net to dblink 0 calls to get snapshot scn: kcmgss 785 calls to kcmgas 47 calls to kcmgcs 1 calls to kcmgrs 0 change write time 0 cleanouts and rollbacks - consistent read gets 0 cleanouts only - consistent read gets 10 cluster key scan block gets 692 cluster key scans 419 cold recycle reads 0 commit cleanout failures: block lost 0 commit cleanout failures: buffer being written 0 commit cleanout failures: callback failure 0 commit cleanout failures: cannot pin 0 commit cleanout failures: hot backup in progress 0 commit cleanout failures: write disabled 0 commit cleanouts 31 commit cleanouts successfully completed 31 consistent changes 10 consistent gets 49935 current blocks converted for CR 10 cursor authentications 33 data blocks consistent reads - undo records applied 0 db block changes 199 db block gets 602 deferred (CURRENT) block cleanout applications 31 dirty buffers inspected 3 enqueue conversions 0 enqueue deadlocks 0 enqueue releases 336 enqueue requests 342 enqueue timeouts 0 enqueue waits 0 exchange deadlocks 0 execute count 640 free buffer inspected 46 free buffer requested 5683 global cache convert time 0 global cache convert timeouts 0 global cache converts 0 global cache cr block receive time 0 global cache cr blocks received 0 global cache cr requests blocked 0 global cache cr timeouts 0 global cache defers 0 global cache freelist waits 0 global cache get time 0 global cache gets 0 global lock async converts 0 global lock async gets 0 global lock convert time 0 global lock get time 0 global lock releases 0 global lock sync converts 0 global lock sync gets 0 hot buffers moved to head of LRU 574 immediate (CR) block cleanout applications 10 immediate (CURRENT) block cleanout applications 0 index fast full scans (direct read) 0 index fast full scans (full) 0 index fast full scans (rowid ranges) 0 instance recovery database freeze count 0 kcmccs called get current scn 0 kcmgss read scn without going to DLM 0 kcmgss waited for batching 0 leaf node splits 0 logons cumulative 8 logons current 7 messages received 56 messages sent 56 native hash arithmetic execute 0 native hash arithmetic fail 0 next scns gotten without going to DLM 0 no buffer to keep pinned count 12588 no work - consistent read gets 23485 opened cursors cumulative 301 opened cursors current 1 opens of replaced files 0 opens requiring cache replacement 0 parse count (hard) 129 parse count (total) 398 parse time cpu 0 parse time elapsed 0 physical reads 5677 physical reads direct 0 physical writes 10 physical writes direct 0 physical writes non checkpoint 10 pinned buffers inspected 43 prefetched blocks 1152 prefetched blocks aged out before use 0 process last non-idle time 0 queries parallelized 0 recovery array read time 0 recovery array reads 0 recovery blocks read 0 recursive calls 8880 recursive cpu usage 0 redo blocks written 71 redo buffer allocation retries 0 redo entries 123 redo log space requests 0 redo log space wait time 0 redo log switch interrupts 0 redo ordering marks 0 redo size 26080 redo synch time 0 redo synch writes 2 redo wastage 9136 redo write time 0 redo writer latching time 0 redo writes 40 remote instance undo block writes 0 remote instance undo header writes 0 rollback changes - undo records applied 0 rollbacks only - consistent read gets 0 rows fetched via callback 1243 serializable aborts 0 session connect time 0 session cursor cache count 0 session cursor cache hits 0 session logical reads 50537 session pga memory 1446820 session pga memory max 1446820 session stored procedure space 0 session uga memory 201508 session uga memory max 241428 sorts (disk) 0 sorts (memory) 103 sorts (rows) 1026 summed dirty queue length 0 switch current to new buffer 0 table fetch by rowid 13458 table fetch continued row 109 table scan blocks gotten 2122 table scan rows gotten 40066 table scans (cache partitions) 0 table scans (direct read) 0 table scans (long tables) 37 table scans (rowid ranges) 0 table scans (short tables) 25 total file opens 49 transaction lock background get time 0 transaction lock background gets 0 transaction lock foreground requests 0 transaction lock foreground wait time 0 transaction rollbacks 0 transaction tables consistent read rollbacks 0 transaction tables consistent reads - undo records applied 0 user calls 65 user commits 0 user rollbacks 0 write clones created in background 0 write clones created in foreground 0