Re: Index usage or last used

Sanjay Mishra wrote:

>Can we check as when Index was last used from the
>dictioanry tables. Index are not in Monitoring mode
>and Statisitic Level is TYPICAL in the Oracle 9i
>database
>
>TIA
>Sanjay
>
>
>
>__________________________________
>Do you Yahoo!?
>Yahoo! Mail - Helps protect you from nasty viruses.
>http://promotions.yahoo.com/new_mail
>--
>http://www.freelists.org/webpage/oracle-l
>
>

V$SEGMENT_STATISTICS is populated nevertheless and it contains the values since the database startup.
Also, V$SEGMENT_STATISTICS is very useful to determine candidates for a reorg. Here is the query
that I use for that purpose:

select owner,object_name,object_type,value from v$segment_statistics
where statistic_name ='ITL waits' and value > 100 /

-- 
Mladen Gogala
Oracle DBA
Ext. 121


--
http://www.freelists.org/webpage/oracle-l