oracle 查看cpu使用率,查看当前最消耗CPU/Memory的oracle进程

--

sessions with the highest time for a certain wait

SELECT

s.sid, s.serial#, p.spid as "OS PID", s.username, s.module,

se.time_waited

FROM

v$session_event se, v$session s, v$process p

WHERE

se.event = '&event_name'

AND

s.last_call_et < 1800 -- active within last 1/2 hour

AND

s.logon_time > (SYSDATE - 240/1440) -- sessions logged on within 4 hours

AND

se.sid = s.sid

AND

s.paddr = p.addr

ORDER

BY se.time_waited;

SQL>

/

Enter

value for event_name: db file sequential read

SID    SERIAL# OS PID

USERNAME

MODULE

TIME_WAITED

----------

---------- ------------ -------------------- ----------------------------------------

-----------

141       1125

15315

SYS

sqlplus@coehq2 (TNS

V1-V3)

4

147        575

10577

SCOTT

SQL*Plus

45215

131        696

10578

SCOTT

SQL*Plus

45529

135        277

10586

SCOTT

SQL*Plus

50288

139        218

10576

SCOTT

SQL*Plus

51331

133        354

10583

SCOTT

SQL*Plus

51428