Re: last time an index was used

Well, I was afraid that you will ask me that. Monitoring is the best way to do 
it. 
There is a sys-owned table called "OBJECT_USAGE", which contains column OBJ#, 
which 
can be joined with OBJECT_ID from dba_objects and there is column "FLAGS". If 
bitwise 
and between FLAGS and 0xFFFF is non-zero, the object was used in the monitoring 
period. 
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: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: