Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DX Lock problem
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