1.vmstat 3(CPU 内存)
2.top(CPU占用,状态state)
3.进程数ps -ef |grep ora|wc -l
4.select sid,event,pl,pltext from v$session_wait(查看存在大量等待进程)
5.根据sid->sqltext:select sql_text from v$sqltext a where a.hash_value=(select sql_hash_value
from v$session b where b.sid='&sid')
order by piece asc
/
6.执行计划 set autotrace trace explain
(查询表的数据量)
6.1是否有用到索引:
select index_name,index_type from user_indexes where table_name='&table_name';
6.2检查索引的键值
select index_name,column_name from user_ind_columns where table_name='&table_name';
7.增加索引:create index in_hs on table_name(column_*);
8.恢复正常
2.top(CPU占用,状态state)
3.进程数ps -ef |grep ora|wc -l
4.select sid,event,pl,pltext from v$session_wait(查看存在大量等待进程)
5.根据sid->sqltext:select sql_text from v$sqltext a where a.hash_value=(select sql_hash_value
from v$session b where b.sid='&sid')
order by piece asc
/
6.执行计划 set autotrace trace explain
(查询表的数据量)
6.1是否有用到索引:
select index_name,index_type from user_indexes where table_name='&table_name';
6.2检查索引的键值
select index_name,column_name from user_ind_columns where table_name='&table_name';
7.增加索引:create index in_hs on table_name(column_*);
8.恢复正常