Oracle数据库管理员职责（四）

核心提示：2. analyze_comp.sql analyze_comp.sqlBEGINSYS.DBMS_UTILITY.ANALYZE_SCHEMA('&OWNER','COMPUTE');END;/3. pop_vol.sqlpop_vol.sqlinsertintoutl_vol_fac

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