Re: Locked Records

From: Buck Turgidson <removethisbeforesending!jc_va_at_hotmail.com>
Date: Sat, 13 Jan 2001 16:59:21 GMT
Message-ID: <JP%76.49$4y6.793@bgtnsc07-news.ops.worldnet.att.net>

I was reading about this on Tom Kyte's website recently. Since you can lock an unlimited number of records in Oracle, it was be a huge performance problem to try and track and store all of them. If you locked every row of a million-row table, you'd have to store those million locked rows in a table.

The best you can do is a find out what object is locked, and by whom.

"Pascal Linder" <pascal_linder_at_yahoo.fr> wrote in message news:3A5ED328.BE33B813_at_yahoo.fr...
> Hi,
>
> I would like to query the database (ORACLE 7.3) about which record is
> currently locked for a given table. Is there any way to proceed ??
>
> Thanx and best regards !
> Pascal
>
Received on Sat Jan 13 2001 - 10:59:21 CST