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: <darthmind_at_gmail.com>
Date: 14 Jul 2005 06:24:49 -0700
Message-ID: <1121347489.520603.103170@g49g2000cwa.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'.




Correct, I am doing this already. But Oracle supports database
instances, and these objects (tables) live in these instances. I'd like
to group the locks on these objects by instance if I can.



tia
Received on Thu Jul 14 2005 - 08:24:49 CDT












Original text of this message













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