Oracle DBA Tasks

We can separate the dba tasks between daily, weekly and monthly procedures:

Daily
- Verify instance status
- Check alerts
- Check configured metrics
- Check RMAN backups
- Check storage
- Check CPU contention
- Check waiting times
- Check memory usage
- Check network load
- Check iostat

Weekly

- Invalid objects
- Tunning: indexes and execution plans
- Top SQL
- Environments consistence
- Review of ressource policy
- Trends and peaks
- Cleaning of alert logs
- Review of RMAN

Monthly

- Recovery tests
- Analyze the data increment trend
- Tunning
- Review I/O
- Fragmentation
- Row chaining
- High Availability Analysis
- Scalability
- Schedule monthly downtime