Tuesday, July 12, 2011

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

No comments: