Oracle DBA Checklist - Weekly Procedures - disPK.sql

Oracle DBA Checklist

(Continued from previous question...)

Oracle DBA Checklist - Weekly Procedures - disPK.sql

-- disPK.sql
--
-- To find out which primary keys are disabled


SELECT owner, constraint_name, table_name, status
FROM all_constraints
WHERE owner = '&OWNER' AND status = 'DISABLED' AND constraint_type = 'P'

(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