
Partial Monitor and Checklist List
| 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 | Partial Proactive Maintenance List
| Category |
Proactive Service |
| Storage Management |
Create/Reallocate DB Files |
| Create/Reallocate Tables, Indexes |
| Create/Reallocate Rollback Segments & other Database Objects |
| Database Management |
New database creation |
| Database networking configuration |
| Determine/Adhere to guidelines for database structures and file layout |
| Review Scripts & Procedures |
| User Management & Security |
Manage users, roles, and profiles |
| Manage schema security |
| Problem Detection & Resolution |
Problem resolution or assistance |
| TAR Management |
| Patch Assistance |
| Backup & Recovery |
Define backup procedures |
| Database recovery assistance |
| Object-level recovery assistance |
| Data Management |
Manage schema objects |
11110000110000001000100010101010111111111111111111111111110000001100000010000000110000001111111111000000101000001010000011001100
|