oracle 资源使用情况查看

oracle中排查问题，遇到资源占用问题，可以使用如下

查询正在执行的SQL语句的详细信息

SELECT s.sid, s.serial#, s.username, s.status, t.sql_id, t.sql_text,
s.last_call_et, s.logon_time, s.program, s.module, s.action
FROM v$session s, v$sqltext_with_newlines t
WHERE s.sql_id = t.sql_id
AND s.status = 'ACTIVE'
AND s.username <> 'SYS';

查看oracle服务器cpu使用率

 SELECT  ROUND((BusyTicks/(IdleTicks+BusyTicks))*100,2) AS "CPU Usage %" FROM
(
   SELECT
   (SELECT VALUE FROM V$OSSTAT WHERE upper(STAT_NAME)='IDLE_TIME') AS IdleTicks,
   (SELECT VALUE FROM V$OSSTAT WHERE upper(STAT_NAME)='BUSY_TIME') AS BusyTicks
   FROM DUAL
) WHERE ROWNUM=1;