My Oracle Support Banner

Send Extract Showtrans Displays Wrong Thread Number of Redo in Integrated Capture Mode (Doc ID 1493770.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle GoldenGate - Version 11.2.1.0.1 and later
Information in this document applies to any platform.

Symptoms

GGSCI> send <group> showtrans count 10

Sending showtrans request to EXTRACT <group> ...

------------------------------------------------------------
XID: 8898.17.12679
Items: 1
Extract: <group>
Redo Thread: 0 <==== wrong thread #
Start Time: 2012-07-02:11:56:42
SCN: 2.722045391 (9311979983)
Redo Seq: 964
Redo RBA: 147984
Status: Running


SQL> select thread#, instance from v$thread where instance = (select instance_name from v$instance);

THREAD#
----------

2

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.