OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Index Monitoring (9.2.0.6.0 IBM AIX)

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

Index Monitoring [message #325223]

Thu, 05 June 2008 05:45

pokhraj_das
Messages: 64
Registered: February 2008

Member

Hi,

I am facing problem during the query of andex monitoring.

I have alter One index as follows:-
=============

sql> Alter Index <INDEX_NAME> monitoring Usage;

Now when I query the "v$object_usage" its showing

SQL> select INDEX_NAME,MONITORING,USED,START_MONITORING from v$object_usage;

no rows selected

Why the view v$object_usage not returing any rows altrough the MONITORING is activated.

Please help.

Pokhraj

Report message to a moderator

Re: Index Monitoring [message #325254 is a reply to message #325223]

Thu, 05 June 2008 06:49

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

scott@gretel_gretel > alter index sys_c004151 monitoring usage;

Index altered.

scott@gretel_gretel > select INDEX_NAME,MONITORING,USED,START_MONITORING from v$object_usage;

INDEX_NAME                     MON USE START_MONITORING
------------------------------ --- --- -------------------
SYS_C004151                    YES NO  06/05/2008 07:47:31

Copy and paste exactly what you did.

Report message to a moderator

Previous Topic:	Please help in tuning
Next Topic:	Question on Object Statistics and Query Execution

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 31 12:01:16 CST 2026