Skip to content
August 14, 2013 / doganay

ZOMBIE PROCESSES


OS

sqlplus -s / as sysdba << EOF | sort > spid.txt
set pages 0
set head off
set feedback off
select spid from v\$process;
EOF
ps -ef | grep oracle | grep "LOCAL=NO" | grep $ORACLE_SID | awk '{i=1;while(i<=NF){printf $i" ";i++};print ""}' | sort | join -v2 -11 -22 spid.txt - | grep -iv extproc


DB

select spid, program from v$process
where program!= 'PSEUDO'
and addr not in (select paddr from v$session)
and addr not in (select paddr from v$bgprocess);
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: