alter index myindex_1 monitoring usage;
alter index myindex_2 monitoring usage;

select * from mytable where ID = 5 -- ID indexed by myindex_1

select index_name, table_name, monitoring, used, start_monitoring,
end_monitoring from V$OBJECT_USAGE;

index_name table_name
monitoring used monitoring FROM
BTMINDX0355_1 TABJ0355 YES YES
05/30/2003 12:16:13
TABJ0355_I_CANALE_ID TABJ0355 YES NO
05/30/2003 12:16:24

I hope it is usefull


-----Messaggio originale-----
Da: SUNIL DBA [mailto:[Email Address Removed] venerdì 30 maggio 2003 12.03
A: LazyDBA.com Discussion
Oggetto: Is My Index is Using by Table or not?


Hi,
I created a ordinary index on a particular column
(Say Emp Table - Empno Column).
Now how I will know that whenever I'm accessing
this table whether index in used or not where I'm
querying based on Empno column. Is there anyway to
check whether my index is useful or not.

Bye !

=====
Sunil Kumar Ramineni,
OCP DBA,
India.

Personal E-Mail : [Email Address Removed] you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page