Oracle DBA Checklist - Nightly Procedures - pop_

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

(Continued from previous question...)

Oracle DBA Checklist - Nightly Procedures - pop_vol.sql

-- pop_vol.sql
--
insert into utl_vol_facts
select table_name
, NVL ( num_rows, 0) as num_rows
, trunc ( last_analyzed ) as meas_dt
from all_tables -- or just user_tables
where owner in ('&OWNER') -- or a comma-separated list of owners
/
commit
/

(Continued on next question...)

Other Job Interview Questions

• Oracle DBA Checklist - Read DBA manuals for one hour - Daily Procedures
• Oracle DBA Checklist - Look for objects that break rules- Weekly Procedures
• Oracle DBA Checklist - Nightly Procedures - mk_volfact.sql
• Oracle DBA Checklist - Look for I/O Contention - Monthly Procedures
• Oracle DBA Checklist -Collect volumetric data - Nightly Procedures
• Oracle DBA Checklist - All tables should have unique primary keys- Weekly Procedures
• Oracle DBA Checklist - Nightly Procedures - pop_vol.sql
• Oracle DBA Checklist - Nightly Procedures - pop_vol.sql
• Oracle DBA Checklist - Read DBA manuals for one hour - Daily Procedures
• Oracle DBA Checklist - -Verify DBSNMP is running - Daily Procedures
• More...