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
>Do you Yahoo!? 
>Yahoo! Mail - Helps protect you from nasty viruses. 
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


Other related posts: