Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Oracle 10.1 Metrics

Metrics were introduced in Oracle 10.1

The following table shows the 142 metrics that were introduced in Oracle 10.1:

Name
Average File Read Time (Files-Long)
Average File Write Time (Files-Long)
Average Users Waiting Counts
Background Checkpoints Per Sec
Blocked User Session Count
Branch Node Splits Per Sec
Branch Node Splits Per Txn
Buffer Cache Hit Ratio
Consistent Read Changes Per Sec
Consistent Read Changes Per Txn
Consistent Read Gets Per Sec
Consistent Read Gets Per Txn
CPU Time (Session)
CPU Time Per User Call
CPU Usage Per Sec
CPU Usage Per Txn
CR Blocks Created Per Sec
CR Blocks Created Per Txn
CR Undo Records Applied Per Sec
CR Undo Records Applied Per Txn
Current Logons Count
Current Open Cursors Count
Cursor Cache Hit Ratio
Database CPU Time Ratio
Database Time Per Sec
Database Time Spent Waiting (%)
Database Wait Time Ratio
DB Block Changes Per Sec
DB Block Changes Per Txn
DB Block Gets Per Sec
DB Block Gets Per Txn
DBWR Checkpoints Per Sec
Disk Sort Per Sec
Disk Sort Per Txn
Elapsed Time Per User Call
Enqueue Deadlocks Per Sec
Enqueue Deadlocks Per Txn
Enqueue Requests Per Sec
Enqueue Requests Per Txn
Enqueue Timeouts Per Sec
Enqueue Timeouts Per Txn
Enqueue Waits Per Sec
Enqueue Waits Per Txn
Execute Without Parse Ratio
Executions Per Sec
Executions Per Txn
Full Index Scans Per Sec
Full Index Scans Per Txn
GC CR Block Received Per Second
GC CR Block Received Per Txn
GC Current Block Received Per Second
GC Current Block Received Per Txn
Global Cache Average CR Get Time
Global Cache Average Current Get Time
Global Cache Blocks Corrupted
Global Cache Blocks Lost
Hard Parse Count (Session)
Hard Parse Count Per Sec
Hard Parse Count Per Txn
Host CPU Utilization (%)
Leaf Node Splits Per Sec
Leaf Node Splits Per Txn
Library Cache Hit Ratio
Library Cache Miss Ratio
Logical Reads Per Sec
Logical Reads Per Txn
Logical Reads Ratio (Sess/Sys) %
Logons Per Sec
Logons Per Txn
Long Table Scans Per Sec
Long Table Scans Per Txn
Memory Sorts Ratio
Network Traffic Volume Per Sec
Number of Sessions Waiting (Event)
Open Cursors Per Sec
Open Cursors Per Txn
Parse Failure Count Per Sec
Parse Failure Count Per Txn
PGA Cache Hit %
PGA Memory (Session)
Physical Block Reads (Files-Long)
Physical Block Writes (Files-Long)
Physical Reads (Files-Long)
Physical Reads (Session)
Physical Reads Direct Lobs Per Sec
Physical Reads Direct Lobs Per Txn
Physical Reads Direct Per Sec
Physical Reads Direct Per Txn
Physical Reads Per Sec
Physical Reads Per Txn
Physical Reads Ratio (Sess/Sys) %
Physical Writes (Files-Long)
Physical Writes Direct Lobs Per Txn
Physical Writes Direct Lobs Per Sec
Physical Writes Direct Per Sec
Physical Writes Direct Per Txn
Physical Writes Per Sec
Physical Writes Per Txn
Process Limit %
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
PX downgraded to serial Per Sec
Recursive Calls Per Sec
Recursive Calls Per Txn
Redo Allocation Hit Ratio
Redo Generated Per Sec
Redo Generated Per Txn
Redo Writes Per Sec
Redo Writes Per Txn
Response Time Per Txn
Row Cache Hit Ratio
Row Cache Miss Ratio
Rows Per Sort
Session Limit %
Shared Pool Free %
Soft Parse Ratio
SQL Service Response Time
Tablespace Space Usage
Total Index Scans Per Sec
Total Index Scans Per Txn
Total Parse Count (Session)
Total Parse Count Per Sec
Total Parse Count Per Txn
Total Table Scans Per Sec
Total Table Scans Per Txn
Total Time Waited
Total Wait Counts
Txns Per Logon
User Calls Per Sec
User Calls Per Txn
User Calls Ratio
User Commits Per Sec
User Commits Percentage
User Limit %
User Rollback Undo Records Applied Per Txn
User Rollback UndoRec Applied Per Sec
User Rollbacks Per Sec
User Rollbacks Percentage
User Transaction Count (Session)
User Transaction Per Sec