How to find index fragmentation in Oracle

• smthembu

  Hall of Fame

  Points: 3463

  More actions

  December 2, 2013 at 10:15 pm

  #395927

  Morning All

  I need your help on how to find index fragmentation in Oracle 11g as i'm new in Oracle, in SQL i use the dmv's to check the index properties

  Thanks

  It's better to fail while trying, rather than fail without trying!!!