Oracle DBA Checklist - Review Tuning Opportunities - Monthly Procedures

Oracle DBA Checklist

(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 Interview Questions

• Oracle DBA Checklist - Verify all instances are up - Daily Procedures
• Oracle DBA Checklist - Look for any new alert log entries - Daily Procedures
• Oracle DBA Checklist - -Verify DBSNMP is running - Daily Procedures
• Oracle DBA Checklist - -Verify free space in tablespaces - Daily Procedures
• Oracle DBA Checklist - -Verify rollback segment - Daily Procedures
• Oracle DBA Checklist - -Identify bad growth projections - Daily Procedures
• Oracle DBA Checklist - Identify space-bound objects - Daily Procedures
• Oracle DBA Checklist - Processes to review contention for CPU, memory, network or disk resources - Daily Procedures
• Oracle DBA Checklist - Copy Archived Logs to Standby Database and Roll Forward - Daily Procedures
• Oracle DBA Checklist - Read DBA manuals for one hour - Daily Procedures
• Oracle DBA Checklist -Collect volumetric data - Nightly Procedures
• Oracle DBA Checklist - Look for objects that break rules- Weekly Procedures
• Oracle DBA Checklist - All tables should have unique primary keys- Weekly Procedures
• Oracle DBA Checklist - All indexes should use INDEXES tablespace. Run mkrebuild_idx.sql - Weekly Procedures
• Oracle DBA Checklist - Look for security policy violations - Weekly Procedures
• Oracle DBA Checklist - Visit home pages of key vendors - Weekly Procedures
• Oracle DBA Checklist - Look for Harmful Growth Rates - Monthly Procedures
• Oracle DBA Checklist - Review Tuning Opportunities - Monthly Procedures
• Oracle DBA Checklist - Look for I/O Contention - Monthly Procedures
• Oracle DBA Checklist - Review Fragmentation - Monthly Procedures
• Oracle DBA Checklist - Project Performance into the Future - Monthly Procedures
• Oracle DBA Checklist - Perform Tuning and Maintenance - Monthly Procedures
• Oracle DBA Checklist - Daily Procedures - Free.sql
• Oracle DBA Checklist - Daily Procedures - Space.sq
• Oracle DBA Checklist - Daily Procedures - analyze5pct.sql
• Oracle DBA Checklist - Daily Procedures - nr_extents.sql
• Oracle DBA Checklist - Daily Procedures - spacebound.sql
• Oracle DBA Checklist - Nightly Procedures - mk_volfact.sql
• Oracle DBA Checklist - Nightly Procedures - analyze_comp.sql
• Oracle DBA Checklist - Nightly Procedures - pop_vol.sql
• Oracle DBA Checklist - Weekly Procedures - nextext.sql
• Oracle DBA Checklist - Weekly Procedures - existext.sql
• Oracle DBA Checklist - Weekly Procedures - No_pk.sql
• Oracle DBA Checklist - Weekly Procedures - disPK.sql
• Oracle DBA Checklist - Weekly Procedures - nonuPK.sql
• Oracle DBA Checklist - Weekly Procedures - mkrebuild_idx.sql
• Oracle DBA Checklist - Weekly Procedures - datatype.sql
• Oracle DBA Checklist - Weekly Procedures - obj_coord.sql