Re: locking with tuxedo

From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Wed, 5 Jan 2011 10:51:34 +0100
Message-ID: <4D243F26.5050406_at_nordea.com>

Remigiusz Sokolowski pisze:
> 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
>
>

and I apologize for not providing some details os: solaris 10, db: 10.2.0.4

-- 
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-l

Received on Wed Jan 05 2011 - 03:51:34 CST