Message-Id: <10675.121589@fatcity.com> From: Vincent Ruger Date: Thu, 9 Nov 2000 16:49:19 +0100 Subject: 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_01C04A64.A0DCAA58 Content-Type: text/plain; charset="iso-8859-1" Hi, On Oracle 7 we used to do that as well SPOOL &1 select 'host kill ' || p.spid from v$session s , v$process p where s.paddr = p.addr and s.status = 'SNIPED' / then execute this script in a cron job (every hour or so) with sqlplus Vincent -----Oorspronkelijk bericht----- Van: root@fatcity.com [mailto:root@fatcity.com]Namens Smith, Ron L. Verzonden: donderdag 9 november 2000 16:11 Aan: Multiple recipients of list ORACLE-L Onderwerp: 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@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 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." -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: rlsmith@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@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_01C04A64.A0DCAA58 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: question about profiles/sniped sessions

Hi,

On Oracle 7 we used to do that as well

SPOOL &1

select 'host kill ' || p.spid
from   v$session s
,      v$process p
where  s.paddr =3D p.addr
and    s.status =3D 'SNIPED'
/

then execute this script in a cron job (every hour or = so) with sqlplus

Vincent

-----Oorspronkelijk bericht-----
Van: root@fatcity.com [mailto:root@fatcity.com]Namens = Smith, Ron L.
Verzonden: donderdag 9 november 2000 16:11
Aan: Multiple recipients of list ORACLE-L
Onderwerp: 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@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
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."

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Smith, Ron L.
  INET: rlsmith@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@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 =