Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Unlocking a table.
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
![]() |
![]() |