Oracle DBA Checklist - Review Tuning Opportuniti

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

(Continued from previous question...)

Oracle DBA Checklist - Review Tuning Opportunities - Monthly Procedures

Review common Oracle tuning points such as cache hit ratio, latch contention, and other points dealing with memory management. Compare with past reports to identify harmful trends or determine impact of recent tuning adjustments.

(Continued on next question...)

Other Job Interview Questions

• Oracle DBA Checklist - Look for objects that break rules- Weekly Procedures
• Oracle DBA Checklist - -Verify free space in tablespaces - Daily Procedures
• Oracle DBA Checklist - Processes to review contention for CPU, memory, network or disk resources - Daily Procedures
• Oracle DBA Checklist - -Verify rollback segment - Daily Procedures
• Oracle DBA Checklist - Nightly Procedures - mk_volfact.sql
• Oracle DBA Checklist - Weekly Procedures - nonuPK.sql
• Oracle DBA Checklist - Look for any new alert log entries - Daily Procedures
• Oracle DBA Checklist - Look for Harmful Growth Rates - Monthly Procedures
• Oracle DBA Checklist -Collect volumetric data - Nightly Procedures
• Oracle DBA Checklist - Visit home pages of key vendors - Weekly Procedures
• More...