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