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 > -- > //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 -- //www.freelists.org/webpage/oracle-l