The row level locks are managed completely inside the
database blocks, therefore none of the v$ tables
can report about these resources. (The granularity
would be to high)
In contrast, table level locks are managed via dml_locks
in internal tables. These tables are available in the
v$ tables/views.
In article <2FVp1.311$By3.265601_at_newsfeed.slurp.net>,
sfinney_at_idir.net (thomas judge & shannon finney) wrote:
> Is there any way to find out what session/user has the lock on the row that I
> want to lock for update (when getting, for example, a resource_lock
exception)?
> Oracle 7.2, AIX 4.1.5 on RS/6000 SP2. We have queries that show all locks,
and
> I can narrow it down to all locks on a table, but is there any way to get the
> one user who has the row that I want? Have talked to Oracle support on this,
> they deny that it is possible or knowledge of how it could be done. My
thought
> is, if the server can figure this out (from the V$ tables, I suppose) I should
> be able to.
>
> Thanks,
> Thomas
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Thu Jul 16 1998 - 02:04:34 CDT
