Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 10.2 Statistics

In Oracle 10.1 there were 332 statistics; in Oracle 10.2 there are 363 statistics

The following table shows the 45 statistics that were added in Oracle 10.2:

Name
auto extends on undo tablespace
commit batch performed
commit batch requested
commit batch/immediate performed
commit batch/immediate requested
commit immediate performed
commit immediate requested
commit nowait performed
commit nowait requested
commit wait performed
commit wait requested
commit wait/nowait performed
commit wait/nowait requested
drop segment calls in space pressure
global undo segment hints helped
global undo segment hints were stale
lob reads
lob writes
lob writes unaligned
local undo segment hints helped
local undo segment hints were stale
physical read bytes
physical read total bytes
physical read total IO requests
physical read total multi block requests
physical write bytes
physical write total bytes
physical write total IO requests
physical write total multi block requests
redo blocks read for recovery
RowCR - resume
SMON posted for dropping temp segment
SMON posted for instance recovery
SMON posted for supplemental logging cleanup
SMON posted for txn recovery for other instances
SMON posted for undo segment recovery
SMON posted for undo segment shrink
space was found by tune down
space was not found by tune down
sql area aged
sql area purged
steps of tune down ret. in space pressure
total number of times SMON posted
tune down retentions in space pressure
undo segment header was pinned

The following table shows the 14 statistics that were removed in Oracle 10.2:

Name
DBWR buffers scanned
DBWR free buffers found
DBWR summed scan depth
kcmccs called get current scn
kcmgss read scn without going to GES
kcmgss waited for batching
next scns gotten without going to GES
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
Unnecesary process cleanup for SCN batching