unfortunately our architecture dynamically makes queries, so I cannot simply get a list of all of the queries being done... and I really prefer not doing sql_trace=TRUE

is there a way to determine if an index is being used? I could used bstats and see how many reads from the tablespace, but it won't tell me if i have 9 indexes there which ones are being used...

I'd like to drop unused ones.. is there an easier way?

thanks.