Oracle Internals
JulianDyke.com

Welcome

Consultancy

Presentations

Diagnostics

Internals

Acknowledgements

Oracle 11.1 Statistics

In Oracle 10.2 there were 363 statistics; in Oracle 11.1 there are 485 statistics

The following table shows the 127 statistics that were added in Oracle 11.1:

Name
Batched IO (bound) vector count
Batched IO (full) vector count
Batched IO (space) vector count
Batched IO block miss count
Batched IO buffer defrag count
Batched IO double miss count
Batched IO same unit count
Batched IO single block count
Batched IO slow jump count
Batched IO vector block count
Batched IO vector read count
Batched IO zero block count
Block Cleanout Optim referenced
blocks helped by sage commit cache
blocks sage cache can process
blocks sage data can process
blocks sage skipped due to chained rows
blocks sage txn can process
bytes via SQL*Net vector from client
bytes via SQL*Net vector from dblink
bytes via SQL*Net vector to client
bytes via SQL*Net vector to dblink
CCursor + sql area evicted
Clusterwide global transactions
Clusterwide global transactions spanning RAC nodes
consistent gets from cache (fastpath)
db block gets from cache (fastpath)
db corrupt blocks detected
db corrupt blocks recovered
DX/BB enqueue lock background get time
DX/BB enqueue lock background gets
DX/BB enqueue lock foreground requests
DX/BB enqueue lock foreground wait time
Effective IO time
failed probes on index block reclamation
Forwarded 2PC commands across RAC nodes
gc local grants
gc reader bypass grants
gc remote grants
GTX processes spawned by autotune
GTX processes stopped by autotune
Heap Segment Array Inserts
Heap Segment Array Updates
HSC Compressed Segment Block Changes
HSC Heap Segment Block Changes
HSC IDL Compressed Blocks
HSC OLTP Compressed Blocks
HSC OLTP compression block checked
HSC OLTP Compression skipped rows
HSC OLTP Drop Column
HSC OLTP inline compression
HSC OLTP negative compression
HSC OLTP Non Compressible Blocks
HSC OLTP positive compression
HSC OLTP recursive compression
HSC OLTP Space Saving
index crx upgrade (found)
index crx upgrade (positioned)
index crx upgrade (prefetch)
LOB table id lookup cache misses
Number of read IOs issued
recovery block gets from cache
recovery blocks read for lost write detection
recovery blocks skipped lost write checks
recursive aborts on index block reclamation
redo blocks checksummed by FG (exclusive)
redo blocks checksummed by LGWR
redo blocks read (memory)
redo blocks read (memory) by LNS
redo blocks read total
redo blocks read total by LNS
redo blocks written for direct writes
redo entries for lost write detection
redo size for lost write detection
sage commit cache queries
sage scans
securefile add dedupd lob to set
securefile allocation bytes
securefile allocation chunks
securefile bytes cleartext
securefile bytes deduplicated
securefile bytes encrypted
securefile bytes non-transformed
securefile compressed bytes
securefile create dedup set
securefile dedup callback oper final
securefile dedup flush too low
securefile dedup hash collision
securefile dedup prefix hash match
securefile destroy dedup set
securefile direct read bytes
securefile direct read ops
securefile direct write bytes
securefile direct write ops
securefile inode ioreap time
securefile inode read time
securefile inode write time
securefile number of flushes
securefile number of non-transformed flushes
securefile reject deduplication
securefile rmv from dedup set
securefile uncompressed bytes
shared io pool buffer get failure
shared io pool buffer get success
sql area evicted
TBS Extension: files extended
TBS Extension: tasks created
TBS Extension: tasks executed
total bytes read and filtered by intelligent storage
total bytes returned by intelligent storage after filtering
transactions found in sage commit cache
Workload Capture: dbtime
Workload Capture: errors
Workload Capture: size (in bytes) of recording
Workload Capture: unreplayable user calls
Workload Capture: unsupported user calls
Workload Capture: user calls
Workload Capture: user calls flushed
Workload Capture: user logins
Workload Capture: user txns
Workload Replay: dbtime
Workload Replay: deadlocks resolved
Workload Replay: network time
Workload Replay: think time
Workload Replay: time gain
Workload Replay: time loss
Workload Replay: user calls

The following table shows the five statistics that were removed in Oracle 11.1:

Name
DBWR make free requests
SMON posted for supplemental logging cleanup
instance recovery database freeze count
redo log switch interrupts
sql area aged