Storage Management

Tablespace Free Space

Rollback Segments

Extent Management

Proactive Performance Monitoring

System resource usage

Basic CPU utilization

Disk related I/O

Basic Network usage

Memory utilization including SGA and shared pool

Inefficient SQL queries

Sorting Efficiency

Hit ratios including buffer cache and shared pool

Contention including redo log and latch

Analyze objects Detection

Temporary Tablespace usage

Lock & Latch Analysis

Problem Detection & Resolution

Alert Log Errors

Database Availability

Listeners 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