My Oracle Support Banner

Rebuilding Index Disable it's monitoring (Doc ID 1588173.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Rebuilding an index resets monitoring status to NO and disable it, below an example:

 

SQL> create index idx_io on TEST(OWNER,OBJECT_NAME,SUBOBJECT_NAME);

Index created.

SQL> alter index idx_io monitoring usage;

Index altered.

SQL> select * from v$object_usage;

INDEX_NAME                     TABLE_NAME                     MON USE START_MONITORING    END_MONITORING
------------------------------ ------------------------------ --- --- ------------------- -------------------
IDX_IO                         TEST           YES NO  02/07/2013 17:53:08

SQL> alter index idx_io rebuild online;

Index altered.

SQL> select * from v$object_usage;

INDEX_NAME                     TABLE_NAME                     MON USE START_MONITORING    END_MONITORING
------------------------------ ------------------------------ --- --- ------------------- -------------------
IDX_IO                         TEST           NO  NO  02/07/2013 17:53:08

 

As from above, the value for MONITORING in v$object_usage has been changed to NO

Also the USED column value has been changed to NO

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.