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 and later
Information in this document applies to any platform.


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?

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


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

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