查看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;