Category |
Monitored List |
Storage Management |
Tablespace Free Space |
Rollback Segments |
Extent Management |
Autoextend Management |
Flat file space used to support logs, dumps, and exports |
Proactive Performance Monitoring |
System resource usage |
Basic CPU utilization |
Disk I/O |
Basic Network I/O |
Memory utilization including SGA and shared pool |
Inefficient SQL |
Sorting Efficiency |
Hit ratios including buffer cache and shared
pool |
Analyze objects Detection |
Archiving |
In-doubt transactions |
Temporary Tablespace usage |
Job Queue Analysis |
Lock & Latch Analysis |
Proactive Performance Monitoring |
Alert Log Errors |
Database Availability |
Listener Availability |
| Low Disk Space/Archive Logs |
| Blocking Locks |
| Core Dumps |
| Backup & Recovery |
Monitor backups for successful completion |
| Flat file space used to support archive logs |
| Monitor Exports for successful completion |
| Data Management |
Monitor object fragmentation |
| Invalid objects |
| Extent failure detection |