Message-Id: <10675.121556@fatcity.com> From: "Koivu, Lisa" Date: Thu, 9 Nov 2000 08:14:33 -0500 Subject: question about profiles/sniped sessions 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 question about profiles/sniped sessions

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