Golden Gate - Find a transaction or is it orphaned? Newbie desires to know.
From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Tue, 23 Jan 2018 13:14:10 -0600
Message-ID: <CAP79kiS7_da4q=5v1CnyeL6=dqgDM8iZ55GkFoVEa2JSheot2g_at_mail.gmail.com>
OGG 12.1.0.2.xx
How can I find the transaction in the DB for that? I'm using this query:
Date: Tue, 23 Jan 2018 13:14:10 -0600
Message-ID: <CAP79kiS7_da4q=5v1CnyeL6=dqgDM8iZ55GkFoVEa2JSheot2g_at_mail.gmail.com>
OGG 12.1.0.2.xx
I have this transaction in my extract:
XID: 159.12.29901130 Items: 1 Extract: EXT_ALL Redo Thread: 3 Start Time: 2018-01-22:19:12:44 SCN: 212.838551413 (911371618165) Redo Seq: 189389 Redo RBA: 12380879828 Status: Running
How can I find the transaction in the DB for that? I'm using this query:
I tried:
SELECT t.start_time
, t.xidusn
|| '.'
|| t.xidslot
|| '.'
|| t.xidsqn
xid
,s.status
,s.sid
,s.serial#
,s.username
,s.status
,s.schemaname
,DECODE ( s.sql_id, NULL, s.prev_sql_id )
sqlid
,DECODE ( s.sql_child_number, NULL, s.prev_child_number )
child
FROM v$transaction t, v$session s
WHERE s.saddr = t.ses_addr
and t.xidusn = 159
But that returns 0 rows - is that an orphan transaction?
Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 23 2018 - 20:14:10 CET