| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 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_01C04A73.DF3B69E2
Content-Type: text/plain;
charset="iso-8859-1"
Thanks Ron and Vincent for your replies. I am glad to hear that someone else had to do the same thing I'm considering doing.
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
"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."
-----Original Message-----
From: Smith, Ron L. [mailto:rlsmith_at_kmg.com]
Sent: Thursday, November 09, 2000 10:11 AM
To: Multiple recipients of list ORACLE-L
Subject: 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
"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_01C04A73.DF3B69E2 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printableReceived on Thu Nov 09 2000 - 11:38:28 CST
<!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>
<P><FONT SIZE=3D2>Thanks Ron and Vincent for your replies. I am =
glad to hear that someone else had to do the same thing I'm considering = doing. </FONT></P>
<BR>
<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 33319</FONT>
</P>
<P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT>
<BR><FONT SIZE=3D2>F: 954.484.2933 </FONT>
<BR><FONT SIZE=3D2>C: 954.658.5849</FONT>
<BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" =
TARGET=3D"_blank">http://www.qode.com</A></FONT>
</P>
<P><FONT SIZE=3D2>"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."</FONT></P>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Smith, Ron L. [<A =
HREF=3D"mailto:rlsmith_at_kmg.com">mailto:rlsmith_at_kmg.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Thursday, November 09, 2000 10:11 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: RE: question about profiles/sniped =
sessions</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>We did the same thing. The story I got from =
Oracle is that the Oracle is</FONT>
<BR><FONT SIZE=3D2>still waiting until the user connects again to tell =
them they were</FONT>
<BR><FONT SIZE=3D2>previously logged off. We had to add a script =
that goes out and looks for</FONT>
<BR><FONT SIZE=3D2>sniped sessions and then issues a kill =
command.</FONT>
<BR><FONT SIZE=3D2> </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>
<BR>
<BR>
<P><FONT SIZE=3D2>Good morning - </FONT>
</P>
<P><FONT SIZE=3D2>I just implemented a profile in our production =
database to kill sessions</FONT>
<BR><FONT SIZE=3D2>idle more than one hour. Our code as it stands =
does not appropriately clean</FONT>
<BR><FONT SIZE=3D2>up after itself (yet). However, I see sniped =
sessions that are still</FONT>
<BR><FONT SIZE=3D2>sitting idle - like 2.5 hours after being =
'sniped'. This concerns me, as</FONT>
<BR><FONT SIZE=3D2>the O/S processes are still there, too. =
</FONT>
</P>
<P><FONT SIZE=3D2>Can anyone tell me when these processes actually get =
cleaned up? I feel</FONT>
<BR><FONT SIZE=3D2>like I have to watch this now, and if that's the =
case then why use the</FONT>
<BR><FONT SIZE=3D2>profile in the first place?</FONT>
</P>
<P><FONT SIZE=3D2>Thanks </FONT>
</P>
<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 33319 </FONT>
</P>
<P><FONT SIZE=3D2>V: 954.484.3191, x174 </FONT>
<BR><FONT SIZE=3D2>F: 954.484.2933 </FONT>
<BR><FONT SIZE=3D2>C: 954.658.5849 </FONT>
<BR><FONT SIZE=3D2><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>> </FONT>
</P>
<P><FONT SIZE=3D2>"The information contained herein does not =
express the opinion or position</FONT>
<BR><FONT SIZE=3D2>of Qode.com and cannot be attributed to or made =
binding upon Qode.com."</FONT>
</P>
<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Smith, Ron L.</FONT>
<BR><FONT SIZE=3D2> INET: rlsmith_at_kmg.com</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
 |
 |