Home > Technical Papers/Books >

  All About Oracle Database Fragmentation (June-01)
 
 
Our Price: Free


Availability: Available for download now
Product Code: DBFRAG

Description
 
There are many types of Oracle database fragmentation. Some are harmful and some are not. An active Oracle database will naturally foster harmful database fragmentation unless the DBA takes proactive application design and space management steps. This paper addresses tablespace freespace, segment, data block, index leaf block, and row fragmentation. Each fragmentation type is described in detail along with how to detect the fragmentation, how to quantify its intensity, what its performance and administration affects are, and how to resolve only the harmful fragmentation. Various scripts are used throughout the paper and references are made to publicly available tools.

Updates

* This paper has not been updated (yet) for 9i and 10g.  There are lots of fragemtation related changes in 10g, but still, this paper should be very valuable.  Craig.

13-June-01. Corrected the tss.sql script output. Fixed the index fragmentation script text (fgidx.sql).

08-June-01. While paper was generally cleaned up and updated, the Index Leaf Block Fragmentation section was significantly updated.

23-March-00. Corrected a statement about index leaf block fragmentation. Leaf block entries are not updated. They are marked for deletion and a new entry is made. This is described in more detail in the paper
 


Browse for more products in the same category as this item:

Technical Papers/Books


Modern Performance Myths - Presentation RMOUG/IOUG/Collab'06/OOW'06 (October 2006) Free
Conquering Oracle Latch Contention (March 2005) IOUG 2005, RMOUG '06, IOUG/Collab 2007 Tech Paper Free
Getting Started Optimizing Oracle Performance PRESENTATION (21-March-2008, IOUG/Collab '08) Free
Oracle DB Server Stress Identifier (v2a) $49.95
Simple Linear Regression Analysis Template (2n 09-July-07) Free
Index Organized Tables -- When should they be used? (April-2002) Free
Getting Started Forecasting Oracle Performance PRESENTATION (21-March-2008, IOUG/Collab '08) Free
All About Oracle's In-Memory Undo (v1n, 22-January-2009) Technical Paper Free
OraPub System Monitor (OSM) Toolkit (v12y for Ora 7-11g, 08-Feb-2010) Free