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: How to get the SQL query of a blocking sid during a lock contention

Re: How to get the SQL query of a blocking sid during a lock contention

From: <bchorng_at_yahoo.com>
Date: 13 Jul 2005 14:59:54 -0700
Message-ID: <1121291994.009511.27240@o13g2000cwo.googlegroups.com> 





Not sure what you meant by "instance". You can always find blockers
from v$lock where block = 1. Once you get the sid, you can do pretty
much anything that is based on sid.



If you are looking for what object is currently being locked, you can
map v$lock.id1 to dba_objects.object_id when block = 1 and type 
= 'TM'.
Received on Wed Jul 13 2005 - 16:59:54 CDT












Original text of this message













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