RE: question about profiles/sniped sessions

From: Vincent Ruger <Vincent.Ruger_at_nos.nl>
Date: Thu, 9 Nov 2000 16:49:19 +0100
Message-Id: <10675.121589@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C04A64.A0DCAA58
Content-Type: text/plain;

charset="iso-8859-1"

Hi,

On Oracle 7 we used to do that as well

SPOOL &1 select 'host kill ' || p.spid
from v$session s
, v$process p
where s.paddr = p.addr
and s.status = 'SNIPED'
/

then execute this script in a cron job (every hour or so) with sqlplus

Vincent

-----Oorspronkelijk bericht-----
Van: root_at_fatcity.com [mailto:root_at_fatcity.com]Namens Smith, Ron L. Verzonden: donderdag 9 november 2000 16:11 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: question about profiles/sniped sessions

We did the same thing. The story I got from Oracle is that the Oracle is still waiting until the user connects again to tell them they were previously logged off. We had to add a script that goes out and looks for sniped sessions and then issues a kill command.

Ron Smith
Database Administration
rlsmith_at_kmg.com

-----Original Message-----
Sent: Thursday, November 09, 2000 7:16 AM To: Multiple recipients of list ORACLE-L

Good morning -

I just implemented a profile in our production database to kill sessions idle more than one hour. Our code as it stands does not appropriately clean up after itself (yet). However, I see sniped sessions that are still sitting idle - like 2.5 hours after being 'sniped'. This concerns me, as the O/S processes are still there, too.

Can anyone tell me when these processes actually get cleaned up? I feel like I have to watch this now, and if that's the case then why use the profile in the first place?

Thanks

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174 
F: 954.484.2933 
C: 954.658.5849

http://www.qode.com <http://www.qode.com>

"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

--

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

Author: Smith, Ron L.
INET: rlsmith_at_kmg.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).

------_=_NextPart_001_01C04A64.A0DCAA58
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: question about profiles/sniped sessions</TITLE>
</HEAD>
<BODY>

Hi,

On Oracle 7 we used to do that as well

SPOOL &1

<P><FONT SIZE=3D2>select 'host kill ' || p.spid</FONT>
<BR><FONT SIZE=3D2>from&nbsp;&nbsp; v$session s</FONT>
<BR><FONT SIZE=3D2>,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; v$process p</FONT>
<BR><FONT SIZE=3D2>where&nbsp; s.paddr =3D p.addr</FONT>
<BR><FONT SIZE=3D2>and&nbsp;&nbsp;&nbsp; s.status =3D 'SNIPED'</FONT>
<BR><FONT SIZE=3D2>/</FONT>
</P>

then execute this script in a cron job (every hour or = so) with sqlplus

Vincent

-----Oorspronkelijk bericht----- Van: root_at_fatcity.com [<A = HREF=3D"mailto:root_at_fatcity.com">mailto:root_at_fatcity.com</A>]Namens = Smith, Ron L.

<BR><FONT SIZE=3D2>Verzonden: donderdag 9 november 2000 16:11</FONT>
<BR><FONT SIZE=3D2>Aan: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Onderwerp: RE: question about profiles/sniped =

sessions

We did the same thing.  The story I got from = Oracle is that the Oracle is
 still waiting until the user connects again to tell = them they were
 previously logged off.  We had to add a script = that goes out and looks for
 sniped sessions and then issues a kill = command.

<BR><FONT SIZE=3D2>&nbsp;</FONT>
<BR><FONT SIZE=3D2>Ron Smith </FONT>
<BR><FONT SIZE=3D2>Database Administration </FONT>
<BR><FONT SIZE=3D2>rlsmith_at_kmg.com </FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, November 09, 2000 7:16 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
</P>

Good morning -

I just implemented a profile in our production = database to kill sessions
 idle more than one hour.  Our code as it stands = does not appropriately clean
 up after itself (yet).  However, I see sniped = sessions    that are still sitting idle - like 2.5 hours after being = 'sniped'.  This concerns me, as

<BR><FONT SIZE=3D2>the O/S processes are still there, too.&nbsp; =
</FONT>
</P>

Can anyone tell me when these processes actually get = cleaned up?  I feel
 like I have to watch this now, and if that's the = case then why use the
 profile in the first place?

Thanks

<P><FONT SIZE=3D2>Lisa Rutland Koivu </FONT>
<BR><FONT SIZE=3D2>Oracle Database Administrator </FONT>
<BR><FONT SIZE=3D2>Qode.com </FONT>
<BR><FONT SIZE=3D2>4850 North State Road 7 </FONT>
<BR><FONT SIZE=3D2>Suite G104 </FONT>
<BR><FONT SIZE=3D2>Fort Lauderdale, FL&nbsp; 33319 </FONT>
</P>

<P><FONT SIZE=3D2>V: 954.484.3191, x174 </FONT>
<BR><FONT SIZE=3D2>F: 954.484.2933 </FONT>

C: 954.658.5849 <A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A> <<A = HREF=3D"http://www.qode.com" =
TARGET=3D"_blank">http://www.qode.com</A>>

"The information contained herein does not = express the opinion or position
 of Qode.com and cannot be attributed to or made = binding upon Qode.com."

-- 
 Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Smith, Ron L.</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: rlsmith_at_kmg.com</FONT>
</P>

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

SIZE=3D2>---------------------------------------------------------------=

-----
 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 = Received on Thu Nov 09 2000 - 09:49:19 CST