Re: Index usage or last used

  • From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
  • To: smishra_97@xxxxxxxxx
  • Date: Tue, 15 Feb 2005 13:46:43 -0500

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: