My Oracle Support Banner

Four Part In XID (Doc ID 2498743.1)

Last updated on APRIL 17, 2023

Applies to:

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

Goal

It appears that in the 12.3 version of goldengate, the XID is showing as 4 positions, not 3 positions as it was in previous versions.
send extract EXTRACT_NAME showtrans 

Then utilizing that output:
------------------------------------------------------------
XID:                   0.10.5.101590814
Items:                13
Extract:              EOLPD1
Redo Thread:      1
Start Time:         2018-11-25:09:25:00
SCN:                  2795.904726062 (12005338318382)
Redo Seq:          643848
Redo RBA:          8455906760
Status: Running



 So what to use to query gv$transaction?


 

Solution

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
Goal
Solution


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