Re: AW: locking with tuxedo

Petr Novak pisze:
> Hallo Remigiusz,
> 
> 
> I cannot answer your question, but may be you could look on these documents:
> 
> http://www.oracle.com/technetwork/database/enterprise-edition/bestpracticesforxaandrac-128676.pdf
> http://www.oracle.com/technetwork/database/clustering/overview/distributed-transactions-and-xa-163941.pdf

Thank You for tips - very valuable indeed, especially the second link.
For those interested:
- it seems there is a possibility in case of distributed transactions,
that there is almost no trails for locks within the database. In short a
distributed transaction, before it becomes a transaction "in-doubt" by
timing out, when a transaction manager is disconnected, is not listed in
anywhere. Locks are held by the tracsaction manager, and the timeout
period must pass to recognize such transaction as "in-doubt" and list it
on dba_2pc_pending.

Regards
Remigiusz

> 
> 
> Best Regards,
> Petr
> ________________________________________
> Von: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx]" im 
> Auftrag von "Remigiusz Sokolowski [remigiusz.sokolowski@xxxxxxxxxx]
> Gesendet: Mittwoch, 5. Januar 2011 10:46
> Bis: oracle-l
> Betreff: locking with tuxedo
> 
> hi,
> 
> we hit from time to time the following issue:
> - some rows from a table are locked
> - there is no blocking session information and the session, which tries
> to acquire lock has blocking_session_status set to NO HOLDER
> 
> The rows are locked by Tuxedo transaction. We suppose we hit the
> situation, when Tuxedo's TRAN_TIME is longer than
> distributed_lock_timeout and it seems setting those values to order
> TRAN_TIME<distributed_lock_timeout will solve this issue.
> 
> Question is how/where to search for more information about the "thing"
> holding lock and if it is possible to release such lock for example by
> forcing a local rollback?
> 
> 
> Regards
> Remigiusz
> 
> 
> --
> Pole nakazi
> 
> ----------------------------------------------------------------------
> Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
> pos   : DBA at DIiUSI
> addr  : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
> phone : +48 58 667 17 43
> mobile: +48 602 42 42 77
> 
> Nordea Bank Polska S.A. z siedzib? w Gdyni, ul. Kielecka 2, 81-303 Gdynia,
> wpisan? do Rejestru Przedsi?biorców Krajowego Rejestru S?dowego pod numerem: 
> 0000021828,
> dla której dokumentacj? przechowuje S?d Rejonowy Gda?sk - Pó?noc w Gda?sku,
> VIII Wydzia? Gospodarczy Krajowego Rejestru S?dowego,
> o kapitale zak?adowym i wp?aconym w wysoko?ci: 227.593.500,00 z?otych,
> NIP: 586-000-78-20, REGON: 190024711
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 
> 


-- 
Pole nakazi

----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski@xxxxxxxxxx>
pos   : DBA at DIiUSI
addr  : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
--
http://www.freelists.org/webpage/oracle-l

Other related posts: