Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 10.1 Statistics

In Oracle 9.2 there were 264 statistics; in Oracle 10.1 there are 332 statistics

The following table shows the 106 statistics that were added in Oracle 10.1:

Name
application wait time
cluster wait time
concurrency wait time
consistent gets direct
consistent gets from cache
db block gets direct
db block gets from cache
DB time
DBWR object drop buffers written
DBWR parallel query checkpoint buffers written
DBWR tablespace checkpoint buffers written
DBWR thread checkpoint buffers written
doubling up with imu segment
flashback log writes
frame signature mismatch
gc blocks corrupt
gc blocks lost
gc claim blocks lost
gc CPU used by this session
gc cr block build time
gc cr block flush time
gc cr block receive time
gc cr block send time
gc cr blocks received
gc cr blocks served
gc current block flush time
gc current block pin time
gc current block receive time
gc current block send time
gc current blocks received
gc current blocks served
global enqueue CPU used by this session
global enqueue get time
global enqueue gets async
global enqueue gets sync
global enqueue releases
heap block compress
IMU bind flushes
IMU commits
IMU contention
IMU CR rollbacks
IMU Flushes
IMU ktichg flush
IMU mbu flush
IMU pool not allocated
IMU recursive-transaction flush
IMU Redo allocation size
IMU undo allocation size
IMU undo retention flush
IMU- failed to get a private strand
IPC CPU used by this session
java call heap collected bytes
java call heap collected count
java call heap gc count
java call heap live object count
java call heap live object count max
java call heap live size
java call heap live size max
java call heap object count
java call heap object count max
java call heap total size
java call heap total size max
java call heap used size
java call heap used size max
java session heap collected bytes
java session heap collected count
java session heap gc count
java session heap live object count
java session heap live object count max
java session heap live size
java session heap live size max
java session heap object count
java session heap object count max
java session heap used size
java session heap used size max
Misses for writing mapping
number of auto extends on undo tablespace
number of drop segment calls under space pressure
number of steps of tune down retentions in space pressure
number of times space was found by tune down
number of times space was not found by tune down
number of tune down retentions under space pressure
physical read IO requests
physical reads cache
physical reads cache prefetch
physical reads direct temporary tablespace
physical reads for flashback new
physical reads prefetch warmup
physical reads retry corrupt
physical write IO requests
physical writes direct temporary tablespace
physical writes from cache
prefetch warmup blocks aged out before use
prefetch warmup blocks flushed out before use
queue flush
queue ocp pages
queue position update
queue qno pages
queue single row
queue splits
queue update without cp update
redo subscn max counts
total number of undo segments dropped
undo change vector size
user I/O wait time
write clones created for recovery

The following table shows the 38 statistics that were removed in Oracle 10.1:

Name
DBWR cross instance writes
global cache blocks corrupt
global cache blocks lost
global cache claim blocks lost
global cache convert time
global cache convert timeouts
global cache converts
global cache cr block build time
global cache cr block flush time
global cache cr block receive time
global cache cr block send time
global cache cr blocks received
global cache cr blocks served
global cache current block flush time
global cache current block pin time
global cache current block receive time
global cache current block send time
global cache current blocks received
global cache current blocks served
global cache defers
global cache freelist waits
global cache get time
global cache gets
global cache prepare failures
global cache skip prepare failures
global lock async converts
global lock async gets
global lock convert time
global lock get time
global lock releases
global lock sync converts
global lock sync gets
opens of replaced files
opens requiring cache replacement
prefetched blocks
remote instance undo block writes
remote instance undo header writes
total file opens