cl scr
prompt Displaying The CPU Intensive Oracle Processes ...
prompt
prompt
!ps -eaf -o pcpu,pid,user,tty,comm | grep ora | grep -v \/sh | grep -v ora_ | sort -r | head -20
column username format a10
column terminal format a9
column sql_text format a50
prompt
prompt
prompt
prompt Enter The UNIX PID :
accept PID
SELECT a.username, a.sid, a.terminal, a.program, b.sql_text
FROM v$session a, v$sqlarea b, v$process c
WHERE ( c.spid = '&PID' OR a.process = '&PID' )
AND a.paddr = c.addr
AND a.sql_address = b.address
/
prompt Displaying The CPU Intensive Oracle Processes ...
prompt
prompt
!ps -eaf -o pcpu,pid,user,tty,comm | grep ora | grep -v \/sh | grep -v ora_ | sort -r | head -20
column username format a10
column terminal format a9
column sql_text format a50
prompt
prompt
prompt
prompt Enter The UNIX PID :
accept PID
SELECT a.username, a.sid, a.terminal, a.program, b.sql_text
FROM v$session a, v$sqlarea b, v$process c
WHERE ( c.spid = '&PID' OR a.process = '&PID' )
AND a.paddr = c.addr
AND a.sql_address = b.address
/
No comments:
Post a Comment