Skip to Main Content
Forums

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!

Index monitoring Overhead

557800Jun 26 2007 — edited Jun 26 2007
Hi,

In my Production system, i have almost 3000 indexes. If i enable Index monitoring on all of them,

ALTER INDEX schema.index_name MONITORING USAGE;

how much overhead or performance degradation will be caused?

Regards,
CT
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 24 2007
Added on Jun 26 2007
#general-database-discussions
1 comment
386 views