How To Handle MLOG$_AP_SUPPLIER_SITES_AL, MLOG$_AP_SUPPLIERS Growing So Much? Having Lots of Data

最新推荐文章于 2021-08-18 18:01:40 发布

caixingyun

最新推荐文章于 2021-08-18 18:01:40 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

分类专栏：错误解决

本文链接：https://blog.youkuaiyun.com/cai_xingyun/article/details/52756899

错误解决专栏收录该内容

48 篇文章

订阅专栏

本文探讨了当Oracle数据库中的MLOG$_AP_SUPPLIER_SITES_AL和MLOG$_AP_SUPPLIERS日志表数据急剧增加时，如何有效管理和优化的策略。内容可能涉及数据清理、归档、索引优化、性能监控以及可能的架构调整。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

How To Handle MLOG$_AP_SUPPLIER_SITES_AL, MLOG$_AP_SUPPLIERS Growing So Much? Having Lots of Data (文档 ID 2108515.1)

In this Document

APPLIES TO:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

GOAL

How to handle MLOG$_AP_SUPPLIER_SITES_AL, MLOG$_AP_SUPPLIERS growing so much?

Both have lots of data.

SOLUTION

Refer to Bug 8614157 , there are two options:

1. Periodically truncating the log tables:

Please watch the growth of the log tables periodically and truncate them whenever they reach the limit.

2. Dropping the log tables:

If you do not use any DBI -- Oracle Daily Business Intelligence, you can drop snapshot log tables:

SQL> drop materialized view log on AP.AP_SUPPLIERS;
SQL> drop materialized view log on AP.AP_SUPPLIER_SITES_ALL;

REFERENCES

BUG:8614157 - MLOG$_AP_SUPPLIER_SITES_AL GROWING LARGE QUICKLY