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

Last updated on APRIL 17, 2023

Applies to:

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

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