1.看看有没有无效的对象; SELECT * FROM DBA_OBJECTS WHERE STATUS='INVALID'; 2.查看有没有被停止的JOB SELECT * FROM DBA_JOBS WHERE BROKEN='Y' OR FAILURES>0; 3.查看当前的锁定,检查有没有出现死锁: select b.owner,b.object_name,b.object_type, a.session_id,a.process,a.locked_mode from v$locked_object a,dba_objects b where a.object_id = b.object_id; 4.检查表空间的增长情况和剩余情况; 5.如果是分布式数据库,检查是否有悬疑事务(DBA_2PC_NEIGHBORS,DBA_2PC_PENDING);
SELECT * FROM DBA_OBJECTS WHERE STATUS='INVALID';
2.查看有没有被停止的JOB
SELECT * FROM DBA_JOBS WHERE BROKEN='Y' OR FAILURES>0;
3.查看当前的锁定,检查有没有出现死锁:
select b.owner,b.object_name,b.object_type,
a.session_id,a.process,a.locked_mode
from v$locked_object a,dba_objects b
where a.object_id = b.object_id;
4.检查表空间的增长情况和剩余情况;
5.如果是分布式数据库,检查是否有悬疑事务(DBA_2PC_NEIGHBORS,DBA_2PC_PENDING);