Day to Day activities of Oracle Apps DBA:
A DBA has to do various activities, it can be listed down according to priority, frequency of that activity. It can be devided in bellow pattern.
- Daily Activities: These are the activities a DBA needs to do daily.
- VERIFY ALL INSTANCES ARE UP
- LOOK FOR ANY NEW ALERT LOG ENTRIES
- VERIFY DBSNMP IS RUNNING
- VERIFY SUCCESS OF DATABASE BACKUP
- VERIFY SUCCESS OF DATABASE ARCHIVING TO TAPE
- VERIFY ENOUGH RESOURCES FOR ACCEPTABLE PERFORMANCE
- READ DBA MANUALS FOR ONE HOUR
- Weekly Activities: These are the activities a DBA needs to excersize weekly.
- LOOK FOR OBJECTS THAT BREAK RULES
- LOOK FOR SECURITY POLICY VIOLATIONS
- LOOK IN SQL*NET LOGS FOR ERRORS, ISSUES
- ARCHIVE ALL ALERT LOGS TO HISTORY
- VISIT HOME PAGES OF KEY VENDORS
- Monthly Procedure: These are the procedures
- LOOK FOR HARMFUL GROWTH RATES
- REVIEW TUNING OPPORTUNITIES
- LOOK FOR I/O CONTENTION
- REVIEW FRAGMENTATION
- PROJECT PERFORMANCE INTO THE FUTURE
PERFORM TUNING AND MAINTENANCE
No comments:
Post a Comment