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
Categories: DBA's day, Definitions, oracle
DBA, Definitions, Oracle
thanku so much , if u r having the real time senarios , plz forward to me.
hai very good information about this
thank u for giving this type of benefits to us….one request to u can u send the real time scenarios to my mail id ladi.avinash88@gmail.com
thank u for giving this type of benefits to us….one request to u can u send the real time scenarios to my mail id kalyan.r123@gmail.com
thank you so much and if you have any more like this could u plese send any real time scenarios to this mail grgrard@gmail.com
thanks and regrds