Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 11.1 Metrics

In Oracle 10.2 there were 163 metrics; in Oracle 11.1 there are 192 metrics

The following table shows the 33 metrics that were added in Oracle 11.1:

Name
Active Parallel Sessions
Active Serial Sessions
Average Active Sessions
Average Synchronous Single-Block Read Latency
Average Wait Time
Consumed CPU Time
CPU Wait Time
DDL statements parallelized Per Sec
DML statements parallelized Per Sec
I/O Megabytes per Second
I/O Requests
I/O Requests per Second
I/O Wait Time
Large Read Requests per Second
Large Write Requests per Second
MegaBytes of I/O
MegaBytes of Large Reads per Second
MegaBytes of Large Writes per Second
MegaBytes of Small Reads per Second
MegaBytes of Small Writes per Second
Number of Waits
PQ QC Session Count
PQ Slave Session Count
PX downgraded 1 to 25% Per Sec
PX downgraded 25 to 50% Per Sec
PX downgraded 50 to 75% Per Sec
PX downgraded 75 to 99% Per Sec
PX operations not downgraded Per Sec
Queries parallelized Per Sec
Session Count
Small Read Requests per Second
Small Write Requests per Second
Streams Pool Usage Percentage

The following table shows the four metrics that were removed in Oracle 11.1:

Name
PX downgraded 25% or more Per Sec
PX downgraded 50% or more Per Sec
PX downgraded 75% or more Per Sec
PX downgraded Parallel Operation Per Sec