Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Identifying users who have a record locked
watsonr4_at_my-deja.com wrote:
>
> Hi:
> There may be a simple query for this, but I've never been able to find
> it. Is there a way to identify which user has a record locked in a
> particular table?
>
> Thanks,
> Ron.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
V$LOCK can give you locking information about a table (although not the actual record) , v$SESSION can give you the rowid if its waiting to get a lock
--
"Some days you're the pigeon, and some days you're the statue." Received on Fri Sep 03 1999 - 04:04:07 CDT