Database Tuning (MOSC)

MOSC Banner

Index Usage

edited Oct 5, 2012 12:21PM in Database Tuning (MOSC) 13 commentsAnswered ✓
Hi All,

DB version is 11.2.0.2

I have enabled index monitoring usage on a index as below

SQL> alter index xxx.xxxxx_ar_01 monitoring usage;
 
Index altered.


Executed few programs and after almost an hour later i did

SQL> alter index xxx.xxxxx_ar_01 NOMONITORING USAGE;
 
Index altered.


After that could see

SQL> select count(*) from v$object_usage;
 
  COUNT(*)
----------
         0
 
1 row selected.


There is zero rows in the v$object_usage table !!! why is it so?

Baskar.l

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center