Oracle DBA Checklist - Weekly Procedures - obj_coord.sql

Oracle DBA Checklist

(Continued from previous question...)

Oracle DBA Checklist - Weekly Procedures - obj_coord.sql

-- obj_coord.sql
--
-- To find out any difference in objects between two instances


SELECT object_name, object_type
FROM user_objects
MINUS
SELECT object_name, object_type
FROM user_objects@&my_db_link

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