My Oracle Support Banner

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

Last updated on JULY 17, 2017

Applies to:

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


GGSCI (host) 31> send etest showtrans count 10

Sending showtrans request to EXTRACT ETEST ...

XID: 8898.17.12679
Items: 1
Extract: ETEST
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);





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

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

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