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