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
>--
>//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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
