Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Materialized view logs pretty huge!

755678Jul 6 2010 — edited Jul 7 2010

Hi,

I have a table MLOG$_XXXXX, which i guess is a materialized view log table. It is huge in size (80GB) and is growing at a very alarming rate.
Could someone please help me to reduce the size of this table?

How do I find out which materialized view is causing this table to grow? Is there any query through which I can find this out?
The database is of version 10204 and is running on HP Unix (B.11.11).

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 4 2010

Added on Jul 6 2010

#general-database-discussions

7 comments

3,298 views