Re: Identify rows being locked

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 27 Jan 2000 22:35:10 +0800
Message-ID: <3890579E.1817@yahoo.com>

Thomas Kyte wrote:
>
> A copy of this was sent to luke.davies
> <luke.daviesNOluSPAM_at_centers.co.uk.invalid>
> (if that email address didn't require changing)
> On Thu, 27 Jan 2000 05:26:59 -0800, you wrote:
>
> >Thanks. But the utllockt.sql script just tells me about the tables
> >that are locked and those people that may be waiting for locks. It
> >only gives me table level information.
> >I need to be able to identify the actual rows that are being locked and
> >any given time.
> >
>
> you cannot. locks on rows are not stored outside of the table -- they are in
> effect stored on the block the row is on. You have to goto a row and try to
> lock it to see if it is locked.
>
> >Cheers
> >
> >Luke
> >
> >
> >* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> >The fastest and easiest way to search and participate in Usenet - Free!
>
> --
> See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
> Current article is "Part I of V, Autonomous Transactions" updated June 21'st
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>
> Opinions are mine and do not necessarily reflect those of Oracle Corporation

Doesn't V$SESSION contain this info ??
--

---

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 Thu Jan 27 2000 - 08:35:10 CST