| 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
Try this:
select 'kill -9 '||spid from v$process where addr in
(select paddr from v$session where status ='SNIPED') /
Regards
Rafiq
From: "Koivu, Lisa" <lkoivu_at_qode.com>
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Subject: RE: question about profiles/sniped sessions
Date: Thu, 09 Nov 2000 09:40:29 -0800
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-----
Sent: Thursday, November 09, 2000 10:11 AM
To: Multiple recipients of list ORACLE-L
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). _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.Received on Thu Nov 09 2000 - 13:56:04 CST
 |
 |