2. analyze_comp.sql
analyze_comp.sql
BEGIN
SYS.DBMS_UTILITY.ANALYZE_SCHEMA('&OWNER','COMPUTE');
END;
/
3. pop_vol.sql
pop_vol.sql
insertintoutl_vol_facts
selecttable_name
,NVL(num_rows,0)asnum_rows
,trunc(last_analyzed)asmeas_dt
fromall_tables
or just user_tables
whereownerin('&OWNER')
or a comma-separated list of owners
/
commit
/
C.每周处理程序
1. nextext.sql
nextext.sql [ 查看全文 ]