Sample – Oracle SLA / OLA Server Response Time Monitoring Considerations
September 6, 2012The following SLA / OLA Oracle Server Counters are supported by Oracle version 10g or higher:
- Number of active connections
- Buffer Cache Hit Ratio
- CPU Usage Per Second
- CPU Usage Per Transaction
- Current Logons Count
- Current Open Cursors Count
- Current OS Load
- Cursor Cache Hit Ratio
- Database CPU Time Ratio
- Host CPU Utilization (Percentage)
- Disk Sort Per Second
- Disk Sort Per Transaction
- Global Cache Average CR Get Time
- Global Cache Average Current Get Time
- Global Cache Blocks Corrupted
- Global Cache Blocks Lost
- Hard Parse Count Per Second
- Hard Parse Count Per Transaction
- Logons Per Second
- Memory Sorts Ratio
- Network Traffic Volume Per Second
- Open Cursors Per Second
- Open Cursors Per Transaction
- Parse Failure Count Per Second
- Parse Failure Count Per Transaction
- PGA Cache Hit Percentage
- Physical Read IO Requests Per Second
- Physical Reads Direct Per Second
- Physical Write IO Requests Per Second
- Physical Write Total IO Requests Per Second
- Physical Writes Direct Per Second
- Physical Writes Per Second
- Process Limit Percentages
- PX downgraded Parallel Operation Per Second
- PX downgraded to serial Per Second
- PX downgraded percentage Per Second
- Recursive Calls Per Second
- Recursive Calls Per Transaction
- Redo Allocation Hit Ratio
- Session Limit Percentage
- Shared Pool Free Percentage
- Soft Parse Ratio