I believe it's integrated but I'm a newbie to GGATE and am troubleshooting
the initial setup.
Chris
On Tue, Jan 23, 2018 at 2:38 PM, Bobby Curtis <curtisbl@xxxxxxxxx> wrote:
First you need to give us more information. Is the extracts classic or
integrated?
V$transaction is where you can see what is being processed by the
database. For OGG this information can be found in the dba_capture view.
Then you should be able to track it from there.
Bobby Curtis
http://about.me/dbasolved
Sent from my iPhone
On Jan 23, 2018, at 14:14, Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
wrote:
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