OS Kill

From: bhabani s pradhan <bhabaniindia_at_rediffmail.com>
Date: Mon, 24 Feb 2003 23:03:44 -0800
Message-ID: <F001.00558009.20030224230344@fatcity.com>

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). Received on Tue Feb 25 2003 - 01:03:44 CST