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: ? regarding lock on rows

Re: ? regarding lock on rows

From: Ed Prochak <edprochak_at_adelphia.net>
Date: Fri, 07 Mar 2003 19:57:18 GMT
Message-ID: <3E68FD4B.60308@adelphia.net>


sricharan saripalli wrote:
> Hi,
>
> Is it possible to find out what rows of a table are locked by the
> current session. I can get the object_id , from v$locked_objects
> for the current user. but i am not sure how to check if a particular row
> is locked or not.
>
> Thanks,
> Charan.
>

Why do you care?

Ask your DBA. If your reason is valid, they will help.

-- 
Ed Prochak
running: http://www.faqs.org/faqs/running-faq/
family:  http://web.magicinterface.com/~collins
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost
Received on Fri Mar 07 2003 - 13:57:18 CST

Original text of this message

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