Oracle数据库巡检(四)
7$ ONLINE
_SYSSMU6_2897970769$ ONLINE
_SYSSMU5_538557934$ ONLINE
_SYSSMU4_1003442803$ ONLINE
_SYSSMU3_1204390606$ ONLINE
_SYSSMU2_967517682$ ONLINE
_SYSSMU1_592353410$ ONLINE
检查数据库的无效对象
SYS@ orcl> col object_name for a20
SYS@ orcl> col owner for a15
SYS@ orcl> select owner, object_name, object_type, status from dba_objects where status != 'VALID' and owner != 'SYS' and owner != 'SYSTEM';
OWNER OBJECT_NAME OBJECT_TYPE STATUS
--------------- -------------------- ------------------- -------
SCOTT USERLIST PROCEDURE INVALID
可以用 Oracle 提供的工具：dbms_utility.compile_schema(schema varchar2， compile_all boolean default TRUE)来编译某个 Schema 下的所有 PROCEDURE、FUNCTION、PACKAGE 和TRIGGER.比如执行 dbms_utility.compile_schema（'Unmi'）。 $ORACLE_HOME/rdbms/admin/utlirp.sql这个可以全部编译所有函数和package
检查
系统资源限制
SYS@ orcl> select * from v$resource_limit;
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION LIMIT_VALUE
------------------------------ ------------------- --------------- -------------------- -----------
processes 29 34 500 500
sessions 35 43 772 772
enqueue_locks 15 29 8960 8960
enqueue_resources 14 37 3616 UNLIMITED
ges_procs 0 0 0 0
ges_ress 0 0 0 UNLIMITED
ges_locks 0 0 0 UNLIMITED
ges_cache_ress 0 0 0 UNLIMITED
ges_reg_msgs 0 0 0 UNLIMITED
ges_big_msgs 0 0 0 UNLIMITED
ges_rsv_msgs 0 0 0 0
gcs_resources 0 0 0 0
gcs_shadows 0 0 0 0
dml_locks 0 0 3396 UNLIMITED
temporary_table_locks 0 0 UNLIMITED UNLIMITED
transactions 0 0 849 UNLIMITED
branches 0 0 849 UNLIMITED
cmtcallbk 0 1 849 UNLIMITED
max_rollback_segments 11 11 849 65535
sort_segment_locks 0 1 UNLIMITED UNLIMITED
k2q_locks 0 0 1544 UNLIMITED
max_shared_servers 1 1 UNLIMITED UNLIMITED
parallel_max_servers 0 0 10 3600
检查数据文件的autoextensible
SYS@ orcl> select tablespace_name, file_id, ONLINE_STATUS, autoextensible from dba_data_files union all select tablespace_name, file_id, status, autoextensible from dba_temp_files;
TABLESPACE_NAME FILE_ID ONLINE_ AUT
------------------------------ ---------- ------- ---
USERS 4 ONLINE YES
UNDOTBS1 3 ONLINE YES
SYSAUX 2 ONLINE YES
SYSTEM 1 SYSTEM YES
TEMP 1 ONLINE YES
检