AW: locking with tuxedo
- From: Petr Novak <Petr.Novak@xxxxxxxxxxxx>
- To: "remigiusz.sokolowski@xxxxxxxxxx" <remigiusz.sokolowski@xxxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 5 Jan 2011 13:49:09 +0000
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
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
