How to get the sid from
From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Sat, 5 Aug 2017 08:33:45 -0300
Message-ID: <CAJdDhaNp4MWP8Vx1HTeL1U=x4uK001JZAwEhA8ch2_VFaueXtw_at_mail.gmail.com>
Hello,
Date: Sat, 5 Aug 2017 08:33:45 -0300
Message-ID: <CAJdDhaNp4MWP8Vx1HTeL1U=x4uK001JZAwEhA8ch2_VFaueXtw_at_mail.gmail.com>
Hello,
I got an error when running this update:
SQL> update col_event set state =0 where state =4 and id =463920006;
update col_event set state =0 where state =4 and id =463920006
ORA-01591: bloqueio retido pela transação distribuída 10.50.1635945
Looking at the result of this query :
select * from dba_2pc_pending where local_tran_id='10.50.1635945';
The dba_2pc_pending contains the column COMMIT# 11345312359643
How can I get the sid, sql_id and also identify the content of this
transaction in order to make decision for COMMIT or ROLLBACK forced.
Is there a way to identify it ?
Regards
Eriovaldo
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Aug 05 2017 - 13:33:45 CEST