Checking the Level of Tablespace Fragmentation

A routine task many DBAs perform is monitoring tablespace fragmentation. But ask DBAs what they mean by tablespace fragmentation, and you’ll most likely get at least several different answers. The reason is twofold. First, there is both confusion and disagreement on what the general term means. And second, there are several kinds of Oracle database fragmentation often referred to when referencing the general term. A quick review of the Oracle fragmentation terminology follows:

  • Tablespace Free space Fragmentation (TFF) occurs when a tablespace contains more than one extent of free space.

  • Segment Fragmentation (SF) occurs when a segment is so large as to consume multiple extents.

  • Data Block Fragmentation ...

Get TOAD® Handbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.