Re: How to know which row is locked ?

On Wed, 30 Sep 1998 18:56:53 +0200, "Jean-Philippe Squelbut" <squelbut_at_csi.com> wrote:

>I don't really know how you tell your row is still locked !
>
>Guillaume MAISON a écrit dans le message <36124631.BF4F7193_at_easynet.fr>...
>>Hi all,
>>
>>here's my problem :
>>
>>in our application, we lock a row to prevent concurent access, and then
>>we process a few works.
>>At the end, the first row should still be locked.
>>
>>our problem is that this row is still locked, but a row from another
>>table is also locked.
>>
>>We'd like to know how to do to identify this second row and its datas ?
>>
>>If anyone has an answer, thanks in advance !
>>
>>Guillaume
>
>

I'm afraid it's not possible. The locking is done inside the database block header. This is what make Oracle so scalable. Unfortunatley there is no way (supplied by Oracle) to determine what row is locked.

Regards

Clive. Received on Sat Oct 03 1998 - 00:00:00 CDT