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: DX Lock problem

Re: DX Lock problem

From: <sorcius_at_gmail.com>
Date: Fri, 29 Jun 2007 03:37:47 -0700
Message-ID: <1183113467.938056.86410@g4g2000hsf.googlegroups.com>


On Jun 28, 6:13 pm, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> On Jun 28, 10:48 am, sorc..._at_gmail.com wrote:
>
>
> Google search:
> oracle dx lock
> or
> oracle dx lock commit rollback
>
> Finds this page:
> http://www.jlcomp.demon.co.uk/faq/find_dist.html
>
> Charles Hooper
> IT Manager/Oracle DBA
> K&M Machine-Fabricating, Inc.

Charles,

that was clear to me... what is not clear is that I can't see the point of acquiring an exclusive lock on an object (whatever the object is, I smell it might be an undo segment) in exclusive mode and serializing all other session.
The symptom is evident in production: once in a while we see this exclusive mode lock of type DX, the database slows down and every single query (select i mean) not necessarly issued from an xa connection against, for example, the gv$global_transaction is there forever.
I am pretty sure is a bug... but I need to reproduce it somehow.

Yes, the distributed_lock_timeout is exactly 9000, as Mladen suggested me, but i can't even force commit or rollback of that in doubt transaction because I can't select from dba_pending_trans.

g Received on Fri Jun 29 2007 - 05:37:47 CDT

Original text of this message

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