|
Oracle DBA Checklist - Nightly Procedures - pop_vol.sql
Oracle DBA Checklist
(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 Interview Questions
| 