Home » RDBMS Server » Performance Tuning » Index Monitoring (9.2.0.6.0 IBM AIX)
Index Monitoring [message #325223] Thu, 05 June 2008 05:45 Go to next message
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
Re: Index Monitoring [message #325254 is a reply to message #325223] Thu, 05 June 2008 06:49 Go to previous message
Mahesh Rajendran
Messages: 10672
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.
Previous Topic: Please help in tuning
Next Topic: Question on Object Statistics and Query Execution
Goto Forum:
  


Current Time: Wed Dec 07 18:38:38 CST 2016

Total time taken to generate the page: 0.09238 seconds