Re: More detailed v$locked_object ??

On 30 Nov 2004 08:20:37 -0800, domenicg_at_hotmail.com (Domenic) wrote:

>Is there a more detailed view to v$locked_object that shows you which
>rows are being locked? If I query v$sql based on the sql_address and
>prev_sql_addr from v$session or query v$open_cursor I can't see the
>statements holding these locks. All I see is SELECTs. I'm on 8.1.7.4
>on Solaris. Any help would be appreciated. Could this be a bug?
>
>Thanks,
>
>Domenic

v$transaction is the v$ view with active transactions. It's address column links back to v$session's taddr column. It also has, IIRC, a kaddr column which links back to v$lock.

Hth

--
Sybrand Bakker, Senior Oracle DBA