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
To find tables that don't match the tablespace default for NEXT extent.
The implicit rule here is that every table in a given tablespace should
use the exact same value for NEXT, which should also be the tablespace's
default value for NEXT.
his tells us what the setting for NEXT is for these objects today.
11/30/98
SELECTsegment_name,segment_type,ds.next_extentasActual_Next
,dt.tablespace_name,dt.next_extentasDefault_Next
FROMdba_tablespacesdt,dba_segmentsds
WHEREdt.tablespace_name=ds.tablespace_name
ANDdt.next_extent!=ds.next_extent
ANDds.owner=UPPER('&OWNER')
ORDERBYtablespace_name,segment_type,segment_name;
2. existext.sql
