【Oracle脚本】消耗CPU高的SQL抓取
【Oracle脚本】消耗CPU高的SQL抓取
查看当前CPU消耗最高的50个用户SQL:
set lines 200 pages 1000
col username format a12
col sql_id format a14
col cpu_used format 999999999
col Mon_time format a18
select * from (
select to_char(sysdate,'yyyymmdd hh24:mi:ss')