Hi all,
I need to find a sql text of a transaction that's pending in a database since yesterday, this is the content of dba_2pc_pending :
LOCAL_TRAN_ID GLOBAL_TRAN_ID STATE MIXED ADVICE TRAN_COMMENT FAIL_TIME FORCE_TIME RETRY_TIME OS_USER OS_TERMINAL HOST DB_USER COMMIT#
---------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
12.10.2402710 1463898948.0000000054E919D70030736A0000562E0000002800000000000000000000001E prepared no 25/02/15 26/02/15 root unknown grcprdtx 2539682364129
1 row selected.
I chekd the v$tansaction in first place :
select * from v$transaction t
where t.xidusn = 12
and t.xidslot = 10
and t.xidsqn = 2402710
no rows selected.
How can I find find the transaction and it's SQL text ?
the version is 10.2.0.5 and OS AIX 5.3
Regards.