Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

How to find locked records in ORACLE

Reinhard Burger
Frequent Advisor

How to find locked records in ORACLE

For some reason a application running against an ORACLE 8.0.6 db reports : locked by another process.
From the application level i cannot find any reason why there is a lock on the records.
I now want to figure out which records are locked in which tables.
Is there any possibility ?
keep it simple
2 REPLIES
Alan Casey
Trusted Contributor

Re: How to find locked records in ORACLE

 
Tom Geudens
Honored Contributor

Re: How to find locked records in ORACLE

Hi,
It has been a while for me, so this is no "complete" solution, but I believe your starting point is :
select * from v$lock;

You can find the sessions that put the locks in there ...

Hope this gets you started ...
Tom

P.S. If you have OEM, you can find this easily in the topsessions window ...
A life ? Cool ! Where can I download one of those from ?