STATISTIC# NAME CLASS ---------- ---------------------------------------------------------------- ---------- 0 logons cumulative 1 1 logons current 1 2 opened cursors cumulative 1 3 opened cursors current 1 4 user commits 1 5 user rollbacks 1 6 user calls 1 7 recursive calls 1 8 recursive cpu usage 1 9 session logical reads 1 10 session stored procedure space 1 11 CPU used when call started 128 12 CPU used by this session 1 13 session connect time 1 14 process last non-idle time 128 15 session uga memory 1 16 session uga memory max 1 17 messages sent 128 18 messages received 128 19 background timeouts 128 20 session pga memory 1 21 session pga memory max 1 22 enqueue timeouts 4 23 enqueue waits 4 24 enqueue deadlocks 4 25 enqueue requests 4 26 enqueue conversions 4 27 enqueue releases 4 28 global lock gets (non async) 32 29 global lock gets (async) 32 30 global lock get time 32 31 global lock converts (non async) 32 32 global lock converts (async) 32 33 global lock convert time 32 34 global lock releases (non async) 32 35 global lock releases (async) 32 36 global lock release time 32 37 db block gets 8 38 consistent gets 8 39 physical reads 8 40 physical writes 8 41 write requests 8 42 summed dirty queue length 8 43 db block changes 8 44 change write time 8 45 consistent changes 8 46 redo synch writes 8 47 redo synch time 8 48 exchange deadlocks 8 49 free buffer requested 8 50 dirty buffers inspected 8 51 free buffer inspected 8 52 commit cleanout failure: write disabled 8 53 commit cleanout failures: hot backup in progress 8 54 commit cleanout failures: buffer being written 8 55 commit cleanout failures: callback failure 8 56 total number commit cleanout calls 8 57 commit cleanout number successfully completed 8 58 DBWR timeouts 8 59 DBWR make free requests 8 60 DBWR free buffers found 8 61 DBWR lru scans 8 62 DBWR summed scan depth 8 63 DBWR buffers scanned 8 64 DBWR checkpoints 8 65 DBWR cross instance writes 40 66 remote instance undo block writes 40 67 remote instance undo header writes 40 68 remote instance undo requests 40 69 cross instance CR read 40 70 recovery blocks read 8 71 recovery array reads 8 72 recovery array read time 8 73 CR blocks created 8 74 Current blocks converted for CR 8 75 calls to kcmgcs 128 76 calls to kcmgrs 128 77 calls to kcmgas 128 78 next scns gotten without going to DLM 32 79 Unnecesary process cleanup for SCN batching 32 80 calls to get snapshot scn: kcmgss 32 81 kcmgss waited for batching 32 82 kcmgss read scn without going to DLM 32 83 kcmccs called get current scn 32 84 redo entries 2 85 redo size 2 86 redo entries linearized 2 87 redo buffer allocation retries 2 88 redo small copies 2 89 redo wastage 2 90 redo writer latching time 2 91 redo writes 2 92 redo blocks written 2 93 redo write time 2 94 redo log space requests 2 95 redo log space wait time 2 96 redo log switch interrupts 2 97 redo ordering marks 2 98 hash latch wait gets 40 99 background checkpoints started 8 100 background checkpoints completed 8 101 serializable aborts 1 102 transaction lock foreground requests 128 103 transaction lock foreground wait time 128 104 transaction lock background gets 128 105 transaction lock background get time 128 106 transaction tables consistent reads - undo records applied 128 107 transaction tables consistent read rollbacks 128 108 data blocks consistent reads - undo records applied 128 109 no work - consistent read gets 128 110 cleanouts only - consistent read gets 128 111 rollbacks only - consistent read gets 128 112 cleanouts and rollbacks - consistent read gets 128 113 rollback changes - undo records applied 128 114 transaction rollbacks 128 115 immediate (CURRENT) block cleanout applications 128 116 immediate (CR) block cleanout applications 128 117 deferred (CURRENT) block cleanout applications 128 118 table scans (short tables) 64 119 table scans (long tables) 64 120 table scans (rowid ranges) 64 121 table scans (cache partitions) 64 122 table scans (direct read) 64 123 table scan rows gotten 64 124 table scan blocks gotten 64 125 table fetch by rowid 64 126 table fetch continued row 64 127 cluster key scans 64 128 cluster key scan block gets 64 129 parse time cpu 64 130 parse time elapsed 64 131 parse count 64 132 execute count 64 133 bytes sent via SQL*Net to client 1 134 bytes received via SQL*Net from client 1 135 SQL*Net roundtrips to/from client 1 136 bytes sent via SQL*Net to dblink 1 137 bytes received via SQL*Net from dblink 1 138 SQL*Net roundtrips to/from dblink 1 139 sorts (memory) 64 140 sorts (disk) 64 141 sorts (rows) 64 142 session cursor cache hits 64 143 session cursor cache count 64 144 cursor authentications 128 145 OS User time used 16 146 OS System time used 16 147 OS Maximum resident set size 16 148 OS Page faults 16 149 OS Page reclaims 16 150 OS Zero-Fill Pages 16 151 OS Resident Set Size increases 16 152 OS Resident Set Size decreases 16 153 OS Swaps 16 154 OS System calls 16 155 OS Voluntary context switches 16 156 OS Involuntary context switches 16 157 OS Signals received 16 158 OS Logical Reads 16 159 OS Logical writes 16 160 OS Disk Reads 16 161 OS Disk writes 16 162 OS Bytes from Logical reads 16 163 OS Bytes from Logical writes 16 164 rows selected.