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

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