Database Software

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!

dbms_stats and mlog$

397530Sep 30 2005 — edited Sep 30 2005

Hi,

Does the 'gather stale' option in dbms_stats work with mlog$ tables?

Since the 'monitor' option in dbms_stats does not turn on monitoring on mlog$ tables I enabled monitoring manually on a couple of mlog$ tables. Ok, fine, but when I try to gather stale statisics, all tables but the mlog$ tables gets analyzed.

At first I thought that those tables did not need to be analyzed, but according to Tom K they need to be analyzed too.

Must I analyze the mlog$ tables manually or am I missing something?

Cheers,
Magnus

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 28 2005

Added on Sep 30 2005

#database-key-features, #replication

1 comment

1,189 views