Untitled

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.

1. VERIFY ALL INSTANCES ARE UP
2. LOOK FOR ANY NEW ALERT LOG ENTRIES
3. VERIFY DBSNMP IS RUNNING
4. VERIFY SUCCESS OF DATABASE BACKUP
5. VERIFY SUCCESS OF DATABASE ARCHIVING TO TAPE
6. VERIFY ENOUGH RESOURCES FOR ACCEPTABLE PERFORMANCE
7. READ DBA MANUALS FOR ONE HOUR

• Weekly Activities: These are the activities a DBA needs to excersize weekly.

1. LOOK FOR OBJECTS THAT BREAK RULES
2. LOOK FOR SECURITY POLICY VIOLATIONS
3. LOOK IN SQL*NET LOGS FOR ERRORS, ISSUES
4. ARCHIVE ALL ALERT LOGS TO HISTORY
5. VISIT HOME PAGES OF KEY VENDORS​

• ​Monthly Procedure: These are the procedures 

1. LOOK FOR HARMFUL GROWTH RATES
2. REVIEW TUNING OPPORTUNITIES
3. LOOK FOR I/O CONTENTION
4. REVIEW FRAGMENTATION
5. PROJECT PERFORMANCE INTO THE FUTURE
   PERFORM TUNING AND MAINTENANCE​

​