RE: Letting users kill their own sessions

[Robson, Peter]

Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle

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-----
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: 30 August 2002 12:53
To: Multiple recipients of list ORACLE-L
Subject: RE: Letting users kill their own sessions

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: [EMAIL PROTECTED]

-----Original Message-----
From: Rodd Holman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 6:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Letting users kill their own sessions

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-----
From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 2:44 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Letting users kill their own sessions


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-----
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 4:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Letting users kill their own sessions


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: [EMAIL PROTECTED]



*********************************************************************
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
*********************************************************************