Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 10.2 Service Statistics

In both Oracle 10.1 and Oracle 10.2 there are 28 service statistics.

There are no differences between the service statistics in the aforementioned versions.

The following table shows the 28 service statistics in Oracle 10.2:

Name
application wait time
cluster wait time
concurrency wait time
db block changes
DB CPU
DB time
execute count
gc cr block receive time
gc cr blocks received
gc current block receive time
gc current blocks received
logons cumulative
opened cursors cumulative
parse count (total)
parse time elapsed
physical reads
physical writes
redo size
session cursor cache hits
session logical reads
sql execute elapsed time
user calls
user commits
user I/O wait time
user rollbacks
workarea executions - multipass
workarea executions - onepass
workarea executions - optimal