Oracle-L: RE: Letting users kill their own sessions

From: Robson, Peter <pgro_at_bgs.ac.uk>
Date: Fri, 30 Aug 2002 05:38:28 -0800
Message-ID: <F001.004C3E8A.20020830053828@fatcity.com>

I quite agree with Patrice - and what's more, 'zombies' is the exact right word for them !

peter
edinburgh

ps - I did get a laugh out of the exchange too....

-----Original Message-----

Sent: 30 August 2002 12:53
To: Multiple recipients of list ORACLE-L

very funny, but I asked because sometimes developers create 'zombies' on our UNIX server.

Why would being chained to a desk that is connected to Oracle be punishment? I don't understand...

; )

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes 
Technology Services        | Services technologiques 
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

-----Original Message-----

Sent: Thursday, August 29, 2002 6:54 PM
To: Multiple recipients of list ORACLE-L

For the really radical there is the 1-finger salute... ;-)

Rodd Holman

On Thu, 2002-08-29 at 16:37, Fink, Dan wrote:

I prefer the Microsoft 3-fingered salute...

-----Original Message-----

Sent: Thursday, August 29, 2002 2:44 PM To: Multiple recipients of list ORACLE-L

Yes, the process is called "logging out" and I normally let them do that. Keeping them tied to their computers would be a cruel and unusual punishment,
against the company policy and probably illegal.

-----Original Message-----

Sent: Thursday, August 29, 2002 4:19 PM To: Multiple recipients of list ORACLE-L

Does anyone have a dynamic script that would let users kill their own sessions?

I found something in Metalink but the script doesn't appear to verify whether the PID and SID supplied belongs to the person executing the procedure... not ideal.

Thanks.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes 
Technology Services        | Services technologiques 
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please

scan all attachments.                            http://www.bgs.ac.uk
*********************************************************************

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Robson, Peter
  INET: pgro_at_bgs.ac.uk

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

Received on Fri Aug 30 2002 - 08:38:28 CDT