Oracle调优
-
编辑 删除
查找最消耗资源的SQL
查找最近一分钟内，最消耗CPU的sql语句select sql_id,count(*),round(count(*)/sum(count(*)) over (),2) pctloadfrom v$active_session_historywhere sample_time > sysdate -1/(24*60)and session_type <> 'BACKGROUND'and session_state= 'ON CPU'group by sql_idorder by count(*) desc; 查找最近一分钟...
