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

Home -> Community -> Usenet -> c.d.o.server -> Re: enqueue wait events, locks and the meaning of id1/id2

Re: enqueue wait events, locks and the meaning of id1/id2

From: Bjorn Augestad <root_at_localhost.com>
Date: Thu, 29 Jan 2004 13:48:03 +0100
Message-ID: <8i7Sb.319$rj4.4334@news2.e.nsc.no> 





Venkat wrote:


> 

> I don't have access to Oracle 8.0.5 so couldn't check if the 

> ROW_WAIT_OBJ#, ROW_WAIT_FILE#, ROW_WAIT_BLOCK# columns exist in 

> V$SESSION. If these columns are there, it would already have all the 

> information required to understand the TX enq row lock waits, no?

> 




The columns exist, but they're all either -1 or 0 for the TX locks.



Bjørn



[snip]
Received on Thu Jan 29 2004 - 06:48:03 CST












Original text of this message













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