Database Administration (MOSC)

MOSC Banner

how to identify the indexes which not used In the past year and drop it

Dears,

we are in oracle database 11.2.0.4.0, our index table space is very huge, almost the same size with the data table space,so i think there must be some indexes are not used, could you pls tell me how to identify the unused indexes? then i want to drop it.

Thank you

Bruce

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center