Can the OGG internal queue tables get truncated manually
(Doc ID 2737954.1)
Last updated on JULY 20, 2024
Applies to:
Oracle GoldenGate - Version 19.1.0.0.4 and laterInformation 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 |