Oracle DBA Checklist - Perform Tuning and Mainte

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Oracle DBA Checklist - Perform Tuning and Maintenance - Monthly Procedures

Make the adjustments necessary to avoid contention for system resources. This may include scheduled down time or request for additional resources.

(Continued on next question...)

Other Job Interview Questions

• Oracle DBA Checklist -Collect volumetric data - Nightly Procedures
• Oracle DBA Checklist - Visit home pages of key vendors - Weekly Procedures
• Oracle DBA Checklist - Processes to review contention for CPU, memory, network or disk resources - Daily Procedures
• Oracle DBA Checklist - Daily Procedures - Free.sql
• Oracle DBA Checklist - Look for objects that break rules- Weekly Procedures
• Oracle DBA Checklist - Weekly Procedures - mkrebuild_idx.sql
• Oracle DBA Checklist - Weekly Procedures - disPK.sql
• Oracle DBA Checklist - Nightly Procedures - analyze_comp.sql
• Oracle DBA Checklist - -Verify free space in tablespaces - Daily Procedures
• Oracle DBA Checklist - All tables should have unique primary keys- Weekly Procedures
• More...