Re: DX Lock problem

On Jun 28, 6:13 pm, Charles Hooper <hooperc2...@xxxxxxxxx> wrote:
On Jun 28, 10:48 am, sorc...@xxxxxxxxx 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



.

Relevant Pages

  • Re: Lock-free databases
    ... > lock, latch, enqueue, or other name is a lock for the purpose of this ... Database concurrency control. ... be it Oracle or SQL Server ...
    (comp.databases.theory)
  • Re: Informix beats Oracle
    ... What's the difference between that and this new feature? ... similar to the Oracle implementation, and was not available in other products. ... Using this, you won't block when trying to read a row that has a lock. ... I'm "tired" of explaining the locking issues to developers that were trained only in Oracle... ...
    (comp.databases.informix)
  • Re: Deadlock - advice needed
    ... Lock table order_release_bp in share mode; ... Resource Name process session holds waits process session holds waits ... After reading about the Oracle locking, my guess is the the stored ... "Unindexed foreign keys cause DML on the primary key to get a share row ...
    (comp.databases.oracle.server)
  • Re: Locking question when using Select clause with For Update and Skip locked
    ... This is working fine in SQL Server and multiple session can get the ... But in Oracle the first session only return 1 row but locks all the ... It looks like both the session got the ROW-X lock but one session is ...
    (comp.databases.oracle.server)
  • Re: PLEASE HELP!!
    ... Run to the nearest book store and buy Tom Kyte's new book " Expert Oracle ... Database Architecture: 9i and 10g Programming Techniques and Solutions". ... Why do you want to lock the rows? ... The reason I ask is that different databases handle different ...
    (comp.databases.oracle.server)