Re: killing oracle processes

From: Nilo Segura <nilosegura_at_gmail.com>
Date: Thu, 20 Aug 2009 11:36:28 +0200
Message-ID: <4ce989e0908200236k5110e83bq17063965cac20ccc_at_mail.gmail.com>

Hi!

At least with releases earlier than 10g, running alter system kill session is not enough, the (unix) process can still remain, so you need to add a little piece of java stored procedure to performa a kill
-9 pid.

In 10g it works better and we barely see the need to kill -9.

We have a web page (using mod_plsql) where users can login and see their own db sessions (plus other info), then they can kill them at will . We are implementing now the concept of power users that can kill other db sessions.

regards.

Nilo Segura
Oracle Support - IT/DES
CERN - Geneva
Switzerland
--

http://www.freelists.org/webpage/oracle-l Received on Thu Aug 20 2009 - 04:36:28 CDT

This message: [ Message body ]
Next message: John Kanagaraj: "Re: GATHER_STATS_JOB"
Previous message: Stefan Knecht: "Re: Function based index with <>"
In reply to: Herring Dave - dherri: "RE: killing oracle processes"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message