Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Identifying users who have a record locked

Re: Identifying users who have a record locked

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 03 Sep 1999 17:04:07 +0800
Message-ID: <37CF8F07.193E@yahoo.com>


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

--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Fri Sep 03 1999 - 04:04:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US