1.查看执行计划,是否有按照WHERE条件执行正常的索引
2.查看最近的表分析情况:
select u.table_name,u.last_analyzed from user_tables u;
3.查询表空间碎片情况
select a.tablespace_name,
trunc(sqrt(max(blocks)/sum(blocks))* (100/sqrt(sqrt(count(blocks)))),2) fsfi
from dba_free_space a,dba_tablespaces b
where a.tablespace_name=b.tablespace_name
and b.contents not in('TEMPORARY','UNDO','SYSAUX')
group by A.tablespace_name
order by fsfi;
低于30%需要做表空间碎片的处理