GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

In OGG 19C, I am observing that GGS_MARKER is generating millions of rows (around 30-40Millions) in

edited May 19, 2020 12:09PM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered

Yes and didn't find similar question asked or answered. Planning to upgrade from OGG 12C to 19C on Oracle Database 12c Enterprise Edition Release 12.1.0.2.0

Source Version :Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO

Target version :  Version 19.1.0.0.200204 OGGCORE_19.1.0.0.0OGGBP_PLATFORMS_200122.0600_FBO

We have DDL replication enabled. GGS_MARKER table is generating millions of rows (around 30-40Millions) in a day itself and also looks like generating lot of audit trail data as well which is consuming lots of database space even for a single day of data. Just FYI, I have enabled MARKER table purge policy for 1 day only because of this huge data generation. Has anyone experienced or observed similar behavior.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center