Re: Locked record - how to find out ?

"Igor V. Podolsky" wrote:

> Pavan <on_jobNOonSPAM_at_usa.net.invalid> wrote in message
> news:09920fb9.3b5fbb61_at_usw-ex0101-005.remarq.com...
>
> > You can find out which record is locked in the Dictionary table V$LOCKS
>
> My database (Oracle 8.1.5 EE) does not contain this view. May be I need run
> some script to create it ?
>
> --
> Is There A God Or Any Kind Of Justice Under The Sky... (Queen'91)
>
> Igor V. Podolsky (igoryok_at_soft-review.kiev.ua)

Well, try v$lock.
Anyway, it wont show you individual row locks. Oracle stores row locks at the block level, so the only way I know of for dumping them is to dump all data blocks for a table and to check for locks in the resulting trace file. Which can get quite rapidly tedious.

--

+-------------------------------------+----------------------------+
| Fred Petillot                       |     fpetillo_at_fr.oracle.com |
| Oracle France - Support Technique   |            +33 1 4762 8201 |
| 65, rue des Trois Fontanot          |            +33 6 8089 5135 |
| 92732 Nanterre Cedex                |                            |
+-------------------------------------+----------------------------+