Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 10.2 Metrics

In Oracle 10.1 there were 142 metrics; in Oracle 10.2 there are 163 metrics

The following table shows the 21 metrics that were added in Oracle 10.2:

Name
Current OS Load
DB Block Changes Per User Call
DB Block Gets Per User Call
DB Time Per Second
DB Time Per User Call
Executions Per User Call
Logical Read Count
Logical Reads Per User Call
Physical Read Bytes Per Sec
Physical Read IO Requests Per Sec
Physical Read Total Bytes Per Sec
Physical Read Total IO Requests Per Sec
Physical Write Bytes Per Sec
Physical Write IO Requests Per Sec
Physical Write Total Bytes Per Sec
Physical Write Total IO Requests Per Sec
Soft Parse Count
Tablespace Bytes Space Usage
Total Sorts Per User Call
Total Table Scans Per User Call
User Calls Per Second

No metrics were removed from Oracle 10.2: