How to Find Fragmentation for Tables and LOBs (Doc ID 2132004.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 8.0.6.0 and later
Information in this document applies to any platform.

Goal

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 :

Automatic Segment Advisor in Oracle 10g Release 2 (10.2) (Doc ID 314112.1)

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms