Originally posted by sysdba
no script, but there is a way.

Put the index into a dedicated tablespace and
use statspack to monitor whether there is read from
that tablespace.
Well, the question was something like that:

"I have 821 indexes on my system and I want to determine which of those 821 indexes is never used."

So you are suggesting to create 821 datafiles, put each index into a sepparate datafile and monitor datafile usage? Or are you suggesting to create one separate tablespace/datafile, and put each index into that tablespace one at a time for a monitoring period? Khm...

Anyway, even if you try to do this index-isolation method you'll find out that is not that straightforward as it seems at first. As chao_ping has allready mentioned, index writes might also cause index reads - some writes will be preceded with reads, some will not. So how will you tell which reads were caused by writes (inserts, deletes, updates) and which were not? Unless of course the table is a read-only one...