556 views
in Tuning by Sr (300 points)

1 Answer

by Sr (340 points)
When there are multiple updates  or deletion  happens on a table it becomes fragmented.

The reason behind fragmentation is, whenever oracle block is used a HWM (high water mark) is set.

HWM is an indicator of used blocks in oracle database. When non insert DML happen say update or delete the space below the HWM is not released by database, causing fragmentation.

One of the solution to fragmentation is reorganization.

Categories

...