| Task # | Task | Frequency |
| 1 | Review all server email notifications | Daily |
| 2 | Review Database Alert Logs for any new errors | Daily |
| 3 | Verify all production instances are up | Daily |
| 4 | Verify success of database backups and archival to tape | Daily |
| 5 | Review disk space on each instance | Daily |
| 6 | Analyze database performance and activity through OEM | Daily |
| 7 | Verify replication is up and running with no errors | Daily |
| 8 | Review Automated Disk Space Report | Daily |
| 9 | Read DBA manuals for one hour | Daily |
| 10 | Review Replication Sync Report | Weekly |
| 11 | Review PROD SGA/PGA Memory Utilization | Monthly |
| 12 | Update Tablespace Growth Spreadsheet 1st of each month | Monthly |
| 13 | Generate Monthy AWR Reports and compare with previous Month | Monthly |
| 14 | Generate Average Active Sessions History Report for Previous Month | Monthly |
| 15 | Analyze Database Growth for Future Projections | Quarterly |
| 16 | Add additional partitions to partitioned tables | Yearly |
Monday, May 18, 2015
Oracle DBA Checklist
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment