Oracle-L: RE: OS Kill

From: Jack van Zanen <JACK_at_QUANTSYSTEMS.NL>
Date: Tue, 25 Feb 2003 00:48:42 -0800
Message-ID: <F001.00558086.20030225004842@fatcity.com>

It's one of those oracle processes that for instance takes care of jobs in the job queue.
They can be killed on oracle level w/o problems (8.0.5 at least). Test it first in test environment

Jack

-----Original Message-----
Sent: dinsdag 25 februari 2003 8:04
To: Multiple recipients of list ORACLE-L

hi list

one session in our database is in ACTIVE state since long. it is doing no activity at all. it has locked one table also. because of this other sessions are also in ACTIVE state. so it is required for us to kill the session.

i got the corresponding spid for that session from v$process.

i checked the following::

$ps -ef | grep <spid>

oracle 21556 1 0 Feb 20 ? 0:09 ora_snp3_TRADEDB1

isn't this the OS process/thread for the oracle background process?

i want to kill the process at OS level if it is not working at DB level

TIA
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: bhabani s pradhan
INET: bhabaniindia_at_rediffmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jack van Zanen
INET: JACK_at_QUANTSYSTEMS.NL

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------