---
title: Database Object Fragmentation in Oracle
description: If a table or index becomes fragmented (not continuous on disk) performance can decrease. Here's how you can see which objects have over 10 extents.
---

[Mertech Blog ](https://www.mertech.com/blog)

# [Database Object Fragmentation in Oracle](https://www.mertech.com/blog/database-object-fragmentation-in-oracle)

 Written by [Mertech](https://www.mertech.com/blog/author/mertech) | Feb 25, 2008 8:40:00 PM

If a table or index becomes fragmented (not continuous on disk) performance can decrease. You can see which objects have over 10 extents with:

select * from dba_segments where extents > 10;

If it is more than 10 it is a candidate for rebuilding.

### To rebuild a table:

- Export the table (with compress=Y)  
- Drop the table  
- Import the table

### To rebuild an index:

- Use Flex2SQL to drop and recreate it. Possibly hand crafting the 'next' storage parameter

**

Recommendation:** Inform customers to check their tables that have possible performance and if they do, recreate them.

 

[View full post](https://www.mertech.com/blog/database-object-fragmentation-in-oracle)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Mertech"
  },
  "dateModified" : "2018-02-27T17:02:05.452Z",
  "datePublished" : "2008-02-25T20:40:00Z",
  "headline" : "Database Object Fragmentation in Oracle",
  "image" : {
    "@type" : "ImageObject",
    "height" : 60,
    "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
    "width" : 60
  },
  "mainEntityOfPage" : "https://www.mertech.com/blog/database-object-fragmentation-in-oracle",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Blog"
  }
}
```