RE: Letting users kill their own sessions

[April Wells]

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

KILL JOY!

-----Original Message-----
From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 29, 2002 3: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]

CSUA 2002:  Imagine the Possibilities!
Corporate Systems Annual Users Association Conference
When: October 2-4, 2002
Where: Caribe Royale Resort   Orlando, FL  USA
For more information go to www.csedge.com



The information contained in this e-mail is strictly confidential and for the intended 
use of the addressee only; it may also be legally privileged and/or price sensitive.  
Notice is hereby given that any disclosure, use or copying of the information by 
anyone other than the intended recipient is prohibited and may be illegal.  If you 
have received this message in error, please notify the sender immediately by return 
e-mail.

Corporate Systems, Inc. has taken every reasonable precaution to ensure that any 
attachment to this e-mail has been swept for viruses.  We accept no liability for any 
damage sustained as a result of software viruses and advise you carry out your own 
virus checks before opening any attachment.