RE: question about profiles/sniped sessions-Solved

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Thu, 9 Nov 2000 08:41:04 -0500
Message-Id: <10675.121560@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_01C04A52.B4CFAB3A
Content-Type: text/plain;

charset="iso-8859-1"

Check that!! Found article 1061189.6 on Metalink that describes how this works (or in this case, does not work). Not what I wanted to hear, but at least now I know. The connections I want to eliminate are not being used any further by the application - that's obvious, as sniped sessions sit there for several hours.

Sorry to bother everyone... I'll look before I leap next time.

Lisa

-----Original Message-----
From: Koivu, Lisa [mailto:lkoivu_at_qode.com] Sent: Thursday, November 09, 2000 8:16 AM To: Multiple recipients of list ORACLE-L Subject: 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 <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_01C04A52.B4CFAB3A
Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>question about profiles/sniped sessions</TITLE>

<META content="MSHTML 5.00.3103.1000" name=GENERATOR></HEAD>
<BODY>
<DIV>Check
that!!  Found article 1061189.6 on Metalink that describes how this works (or in this case, does not work).  Not what I wanted to hear, but at least now I know.  The connections I want to eliminate are not being used any further by the application - that's obvious, as sniped sessions sit there for several hours.  </DIV>
Sorry to
bother everyone...  I'll look before I leap next time.
<SPAN
class=505033713-09112000>Lisa
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">

<DIV align=left class=OutlookMessageHeader dir=ltr>-----Original Message----- From: Koivu, Lisa [mailto:lkoivu_at_qode.com] Sent: Thursday, November 09, 2000 8:16 AM To: Multiple recipients of list ORACLE-L Subject: question about profiles/sniped sessions </DIV> 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="http://www.qode.com" target=_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."</BLOCKQUOTE></BODY></HTML> Received on Thu Nov 09 2000 - 07:41:04 CST