【翻译自mos文章】控制OGG Director 中Repository Table 保留几天记录的参数

最新推荐文章于 2024-04-28 20:53:17 发布

翻译最新推荐文章于 2024-04-28 20:53:17 发布 · 1.3k 阅读

Oracle GoldenGate 专栏收录该内容

101 篇文章

订阅专栏

本文介绍如何通过调整LogPurgeHours参数来控制OGGDirector中的RepositoryTable（STATSENTRYB）记录保留时间。默认情况下，该表记录保留72小时，通过Director Admin Tool可以更改此设置。

控制OGG Director 中Repository Table 保留几天记录的参数

翻译自mos文章：
Can I Purge The Director "STATSENTRYB" Repository Table? (Doc ID 971709.1)

QUESTION

My Director Repository Table "STATSENTRYB" has grown to more than 100,000 rows.  Is there a way to purge that table?

SOLUTION
There is a parameter to control how long records are retained in this table.  Using the Director Admin Tool, click on the  
Monitor Agent Tab.  The Log Purge Hours controls the number of hours records are retained in both the 
"STATSENTRYB" and the "LOGENTRYB" tables.  The default is 72 hours.

Once you make a change to that parameter, hit the Save and Restart Button.  This will update the Database Repository  
but you will have to also reboot the Director Server for it to pickup and apply this change.