Operating System - HP-UX
1748166 Members
3686 Online
108758 Solutions
New Discussion юеВ

Re: 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 2
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 ?