Saturday, 28 November 2015

To display the CPU intensive unix processes and then display the SQL text for one of the process

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
/

No comments:

Post a Comment