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


Multiple Linear Regression Analysis Template (2g 12-April-07) Free
All About Oracle's Touch-Count Data Block Buffer Algorithm (Jan 2004) Free
Oracle Performance Firefighting Book in *PDF* (OraPub) $39.95
Erlang-C Mathematics in Perl (1a,Jan 2007) Free
Piranhas In The Pool, SQL Performance Killers (July 2001) Free
Introduction To Oracle Server Consolidation (v2b, 10-February-2009) Technical Paper Free
Firefighting Diagnostic Template (1h, 17-June-2010) Free
Oracle Table Compression (Sept-2005) Free
Forecasting data collection script for Oracle and OS (v1.2 03-Sept-2008) Free