question about profiles/sniped sessions

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Thu, 9 Nov 2000 08:14:33 -0500
Message-Id: <10675.121556@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_01C04A4F.00BBF084
Content-Type: text/plain;

charset="iso-8859-1"

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

"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."

------_=_NextPart_001_01C04A4F.00BBF084
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>question about profiles/sniped sessions</TITLE>
</HEAD>
<BODY>

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
 <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." Received on Thu Nov 09 2000 - 07:14:33 CST