Re: last time an index was used

  • From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
  • To: Ruth Gramolini <rgramolini@xxxxxxxxxxxxxxx>
  • Date: Fri, 2 Apr 2004 12:03:08 -0500

Well, I was afraid that you will ask me that. Monitoring is the best way to do 
There is a sys-owned table called "OBJECT_USAGE", which contains column OBJ#, 
can be joined with OBJECT_ID from dba_objects and there is column "FLAGS". If 
and between FLAGS and 0xFFFF is non-zero, the object was used in the monitoring 
Here is the function that oracle uses to define that view:
         decode(bitand(i.flags, 65536), 0, 'NO', 'YES'),
Of course, that is not officially sanctioned. Please, have mercy on me on 15/04.

On 04/02/2004 11:47:57 AM, Ruth Gramolini wrote:
> Mladan,
> Thanks for your speedy answer. However,I want to look at all the indexes in
> our production schema and see which ones are not used. Isn't there some sys
> table that records this?  Isn't there another way, besides turning
> monitoring on?
Mladen Gogala
Oracle DBA
Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: