How to Find Fragmentation for Tables and LOBs
(Doc ID 2132004.1)
Last updated on JUNE 11, 2020
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
This document provides steps to find fragmentation at segment level. Note that in this document MANUAL methods of finding fragmentation have been discussed. Oracle has automated fragmentation checks from 10.2 onward via Automatic Segment Advisor. Further details on Sgment Advisor are given in :
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|1. Tables in MSSM (Manual Segment Space Management) tablespaces|
|2. Tables in ASSM(Automatic Segment Space Management) tablespaces|
|3. LOBs in MSSM(Manual Segment Space Management) tablespaces|
|4. LOBs in ASSM (Automatic Segment Space Management) tablespaces|
|5. Securefile LOBs|