Re: sniped sessions

From: <Jared.Still_at_radisys.com>
Date: Mon, 14 Jan 2002 15:49:24 -0800
Message-ID: <F001.003EFAC6.20020114152026@fatcity.com>

Here's a very rough cut at a script to generate a batch file to kill the threads.

orakill.sql set head off feed off linesize 100 pagesize 0

spool okill.bat

select

'orakill ' || i.instance_name || ' ' || p.spid from v$process p, v$session s, v$instance i where p.addr=s.paddr
and s.status = 'SNIPED'
/

spool off

exit

from the command line:

sqlplus system/manager @orakill.sql okill.bat

Jared

                                                                                       
                             
                    Sunil_Nookala@                                                     
                             
                    Dell.com             To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>        
                    Sent by:             cc:                                           
                             
                    root_at_fatcity.c       Subject:     sniped sessions                  
                             
                    om                                                                 
                             
                                                                                       
                             
                                                                                       
                             
                    01/14/02 02:10                                                     
                             
                    PM                                                                 
                             
                    Please respond                                                     
                             
                    to ORACLE-L

Dear List,

I have "init.ora" resource_limit = true, and idle_time set in profile. When idle_time exceeds, the session status becomes 'sniped' in v$session and
never gets cleaned up.
I manually kill these threads using orakill utility.

I appreciate, if someone can help me with a script to clean up these sessions automatically(8.1.7 on NT)??

Sunil Nookala
DBA
Dell Computer Corp.
Austin, TX 78738
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Sunil_Nookala_at_Dell.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


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

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


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

To REMOVE yourself from this mailing list, send an E-Mail message