查看sql语句执行计划并重建索引
晚上cpu报警显示当前cpu使用率达到90%以上,不到10%的空闲
先查询当前sql:
#(ORACLE)
SQL >
set line 200 pages 1000
col event for a30
col program for a30
col username for a12
col sql_id for a15
col INST_ID for 9999
col machine for a15
select inst_id,sid,serial#,username,sql_id,event,program,machine,last_call_et,status from gv$session
where wait_class'Idle'
order by last_call_et;