Thanks to suggestions made by Frits Hoogland, I made some improvements to the ODBV. The new version can be found here: http://ora-600.pl/oinstall/odbv.x86_64
The changes are:
- Recognition of first, second and third level bitmap block
- Recognition of pagetable segment header
- Block number ranges on the left side
The blocks will be coloured properly to belonging segment.
Here you can find a sample output:
If you want to start with ODBV, check out this posts:
- oracle database block visualizer
- back to the basics: truncate table reuse storage vs drop storage
- back to the basics: alter table move vs shrink
Have fun! 🙂