select segment_name,status from dba_rollback_segs;
set heading off
select ' 8、检查是否有禁用约束' from dual;
set heading on
set linesize 1000
SELECT owner, constraint_name, table_name, constraint_type, status
FROM dba_constraints
WHERE status ='DISABLE' and constraint_type='P';
set heading off
select ' 9、检查是否有禁用触发器' from dual;
set heading on
col owner for a10
col taigger_name for a10
col table_name for a30
col table_name for a30
SELECT owner, trigger_name, table_name, status FROM dba_triggers WHERE status =
'DISABLED';
set heading off
select ' 10、Job Disable' from dual;
set heading on
select job,what,last_date,next_date,failures,broken from dba_jobs Where
schema_user='CAIKE';
set heading off
select ' 11、检查失效的索引' from dual;
set heading on
select index_name,table_name,tablespace_name,status From dba_indexes Where
owner='CTAIS2' And status<>'VALID';
set heading off
select '三、检查 Oracle 相关资源的使用情况' from dual;
set heading off
select ' 1、查看表空间的使用情况' from dual;
set heading on
set linesize 1000
SELECT UPPER(F.TABLESPACE_NAME) "tablespace_name",
D.TOT_GROOTTE_MB "tablesapce_size(M)",
D.TOT_GROOTTE_MB - F.TOTAL_BYTES "used_tablespace_size(M)",
相关文档
评论