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

Other related posts: