locking with tuxedo
From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Wed, 5 Jan 2011 10:46:02 +0100
Message-ID: <4D243DDA.5010607_at_nordea.com>
hi,
Date: Wed, 5 Jan 2011 10:46:02 +0100
Message-ID: <4D243DDA.5010607_at_nordea.com>
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_at_nordea.com> 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-lReceived on Wed Jan 05 2011 - 03:46:02 CST