oracleoddsandends.wordpress.com
Freeing Empty Index Blocks with Automatic Segment Management
This post is a work in progress, just some observations with no conclusion (yet).We have a table with an ID column generated from a sequence and an index on the ID column. From time to time, cleanu…