OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » index monitoring

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

index monitoring [message #156581]

Thu, 26 January 2006 01:22

vijaychauhan
Messages: 106
Registered: December 2005

Senior Member

I am monitoring index using alter index indexname monitoring usage and then using v$object_usage, Then I accessed the table, then it showed yes in v$object_usage for index used column, how long will this column hold the vales yes, if I do not use the index again.

Report message to a moderator

Re: index monitoring [message #156614 is a reply to message #156581]

Thu, 26 January 2006 08:22

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

The values in v$object_usage will be reseted when the instance is bounced (restarted).

Report message to a moderator

Re: index monitoring [message #156630 is a reply to message #156614]

Thu, 26 January 2006 09:48

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

It will be set to no when you issue
alter index indexname nomonitoring usage;
then
alter index indexname monitoring usage;

SQL> alter index tidx monitoring usage;

Index altered.

SQL> select * from v$object_usage;

INDEX_NAME                     TABLE_NAME                     MON USE
------------------------------ ------------------------------ --- ---
START_MONITORING    END_MONITORING
------------------- -------------------
TIDX                           T                              YES NO
01/26/2006 15:43:04


SQL> select * from t where employee_id = 100;

no rows selected

SQL> select * from v$object_usage;

INDEX_NAME                     TABLE_NAME                     MON USE
------------------------------ ------------------------------ --- ---
START_MONITORING    END_MONITORING
------------------- -------------------
TIDX                           T                              YES YES
01/26/2006 15:43:04


SQL> alter index tidx nomonitoring usage;

Index altered.

SQL> select * from v$object_usage;

INDEX_NAME                     TABLE_NAME                     MON USE
------------------------------ ------------------------------ --- ---
START_MONITORING    END_MONITORING
------------------- -------------------
TIDX                           T                              NO  YES
01/26/2006 15:43:04 01/26/2006 15:43:59


SQL> alter index tidx monitoring usage;

Index altered.

SQL> select * from v$object_usage;

INDEX_NAME                     TABLE_NAME                     MON USE
------------------------------ ------------------------------ --- ---
START_MONITORING    END_MONITORING
------------------- -------------------
TIDX                           T                              YES NO
01/26/2006 15:45:02

HTH
Jim

[Updated on: Thu, 26 January 2006 09:51]

Report message to a moderator

Re: index monitoring [message #156821 is a reply to message #156581]

Sat, 28 January 2006 04:17

vijaychauhan
Messages: 106
Registered: December 2005

Senior Member

thanks

Report message to a moderator

Previous Topic:	REUSE option-tablespace
Next Topic:	DataMining Option

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 15:38:16 CST 2025