How do i find if my secondary index is being used from the DBC tables? I know i can find that out from Explain plan. However anything that we could get the list of all the SI usage across the tables from teh metadata itself?
Note we are on 15.10 and we have not enabled the DBQLOBJ table.
Sounds like you may already know the answer.
You need to have DBQL OBJECTS or USECOUNT logging enabled, or look at the EXPLAIN.