virtual circuit status event


SELECT 'kill -9 ' || p.SPID
   FROM v$session_wait w, v$session s, v$process p
 WHERE w.event = 'virtual circuit status'
    AND s.SID = w.SID
    AND s.paddr = p.addr
    AND s.TYPE <> 'BACKGROUND'
    and seconds_in_wait > 50;
 
 SELECT 'kill -9 ' || p.SPID
    FROM v$session_wait w, v$session s, v$process p
   WHERE w.event = 'SQL*Net message from client'
     and s.username = 'PSTSMSLIVE'
     AND s.SID = w.SID
     AND s.paddr = p.addr
     AND s.TYPE <> 'BACKGROUND'
     and seconds_in_wait > 36000;

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: