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 -> More detailed v$locked_object ??

More detailed v$locked_object ??

From: Domenic <domenicg_at_hotmail.com>
Date: 30 Nov 2004 08:20:37 -0800
Message-ID: <c7e08a19.0411300820.7bc3cb8@posting.google.com> 





Is there a more detailed view to v$locked_object that shows you which
rows are being locked?  If I query v$sql based on the sql_address and
prev_sql_addr from v$session or query v$open_cursor I can't see the
statements holding these locks.  All I see is SELECTs.  I'm on 8.1.7.4
on Solaris.  Any help would be appreciated.  Could this be a bug?



Thanks,



Domenic
Received on Tue Nov 30 2004 - 10:20:37 CST












Original text of this message













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