My Oracle Support Banner

Can the OGG internal queue tables get truncated manually (Doc ID 2737954.1)

Last updated on JANUARY 22, 2021

Applies to:

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

Goal

DBaaS-GPO: GWB-BGPOS02: GGSADMIN objects are growing.....

Problem Description
---------------------------------------------------
Following type of tables are growing an is there a way to truncate these tables?

TABLE_NAME NUM_ROWS
-------------------------------------------------------------------------------------------------------------------------------- ----------
AQ$_QT$_OGG$RGPORC12_10_C 19230
AQ$_QT$_OGG$RGPORC12_10_H 172531
AQ$_QT$_OGG$RGPORC12_10_I 172531
AQ$_QT$_OGG$RGPORC21_5_C 3049
AQ$_QT$_OGG$RGPOS2S1_2_C 7335933
AQ$_QT$_OGG$RGPOS2S1_2_H 64904
AQ$_QT$_OGG$RGPOS2S1_2_I 64904
AQ$_QT$_OGG$RGPOSC12_9_C 4660646
AQ$_QT$_OGG$RGPOSC12_9_H 27346
AQ$_QT$_OGG$RGPOSC12_9_I 27346
AQ$_QT$_OGG$RGPOSC21_6_C 75660
 

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.