|
Category
| What's Monitored |
| 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 |
