Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Unlocking a table.

Re: Unlocking a table.

From: Sukumar Kurup <sukuora_at_yahoo.com>
Date: Fri, 12 Jan 2001 17:28:19 -0800 (PST)
Message-Id: <10739.126603@fatcity.com>


Hi Anindya,

The following from metalink may be useful :

You may have killed the client process and there is still a shadow process for this session running. The shadow process can be tricky to identify. It may take considerable searching by the dba who is familiar with the os and database environment to identify the process.
You might look for processes with a parent pid of 1, meaning that they are owned by the system. Also, look for processes with a start time that matches the start time of the killed process.

Sukumar Kurup



Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online! http://photos.yahoo.com/ Received on Fri Jan 12 2001 - 19:28:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US