Re: Golden Gate - Find a transaction or is it orphaned? Newbie desires to know.

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_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l