My Oracle Support Banner

Goldengate Integrated/Parallel Integrated Replicat is slow due to Top Level VARRAY (Doc ID 2696426.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

Database version is 12.1.0.2 .


Goldengate Integrated/Parallel Integrated Replicat is slow due to Top Level VARRAY

Top level VARRAY causes unsupported datatype fallback :


GGSCI > stats <rep_name>, reportrate min

Sending STATS request to REPLICAT <rep_name>...

Start of Statistics at 2019-11-06 21:20:27.

Integrated Replicat Statistics:

       Total transactions                              3022.00
       Redirected                                         0.00
       Replicated procedures                              0.00
       DDL operations                                     0.00
       Stored procedures                                  0.00
       Datatype functionality                          3022.00           <<<<<<<<<
       Operation type functionality                       0.00
       Event actions                                      0.00
       Direct transactions ratio                        100.00%

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.