Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy



Rampant Oracle In-Focus Series


  Oracle Space Management Handbook

Donald K. Burleson, Jonathan Lewis, Dave Ensor, Mike Hordila, John Weeg, Arup Nanda, Dave Moore, Christopher Foot, Lisa Hernandez


ISBN: 0-9744355-0-3
311 Pages

Retail Price $24.95 / £17.95 

- Order now and get 30% off the retail price!

Only $19.95



Written by some of the world's most widely-read authors, this exciting eBook provides you with everything that you need to know to manage Oracle storage. You will learn how to monitor and reduce disk I/O, how to set-up your tablespaces for maximum efficiency and how to define Oracle tables and indexes to make the most efficient use of disk storage. Not for the beginner, this is a guru-level advanced Oracle handbook with highly-detailed explanations of Oracle storage internals. This eBook is laden with useful scripts that will allow you to quickly see inside your data files and tablespaces and tune them for optimal performance.


Key Features

* Shows how to effectively define Oracle data files for maximum performance.

* Learn to measure Oracle segment I/O.

* Understand how to reduce Oracle disk I/O.

* See how to resize an Oracle data file.

* Monitor the Oracle storage system with advanced SQL scripts.

* Automate critical storage tasks including automating Oracle table reorganizations.

* Understand the proper techniques for sizing Oracle index segments.

* See how to use Oracle9i external tables.

* Learn about table and index partitioning.

* See how to read segment internal dumps.

* Understand Oracle9i multiple blocksizes.

* See how automatic segment space management works.

* Learn about locally-managed tablespaces.

* Contains ready-to-run expert data dictionary scripts.


About the Authors:
This eBook is authored by some of the world's leading experts.


Don Burleson

Don Burleson is one of the world’s top Oracle Database experts with more than 20 years of full-time DBA experience.  He specializes in creating database architectures for very large online databases and he has worked with some of the world’s most powerful and complex systems.   A former Adjunct Professor, Don Burleson has written 32 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Oracle Internals. Don is a popular lecturer and teacher and is a frequent speaker at Oracle Openworld and other international database conferences.

Click here for Don Burleson's books
Click here for Don Burleson articles


Jonathan Lewis

  Jonathan Lewis, author of "Practical Oracle 8i - Building Efficient Databases". Jonathan has more than 17 years experience with the Oracle RDBMS, is a regular presenter at UKOUG SIGs, and is the designer and presenter of the seminar "Optimizing Oracle - performance by design".

Dave Ensor

  Dave Ensor worked for Oracle for 7 years as a worldwide performance specialist and has been working with Oracle databases for 15 years. In total, he has over 35 years active programming and design experience. As an Oracle design and tuning specialist, Dave has built a global reputation for finding cost-effective solutions to Oracle performance problems and for his ability to explain performance issues to technical audiences with both clarity and humor.

Arup Nanda


Arup Nanda is the recipient of the coveted DBA of the Year 2003 award by Oracle Corporation.  This award is among the most highly coveted in the database industry, and each year only one of more than a quarter million Oracle professionals is honored by this distinction.  A decade of experience as a DBA has made Arup an expert in many Oracle areas including Oracle Design, Oracle Modeling, Oracle Performance Tuning and Oracle Backup & Recovery.

Arup is a frequent speaker in many Oracle related conferences including IOUG Live and has written several Oracle related articles in technical journals in the US and Europe. He is on the editorial board for SELECT Journal, the publication of the International Oracle Users Group.



Dave Moore


Dave Moore is a Product Architect at BMC Software, a leading supplier of database software tools.  As the inventor of BMC's DBXray product, he has developed many products that assist Oracle DBAs and Developers.  He has over 13 years of experience in Information Technology - as a DBA and as a developer specializing in Oracle, Java and PL/SQL.   Dave has presented at Oracle OpenWorld and is a frequent contributor to Oracle Professional and DBAZine.  He holds a BS in Information Systems from Western Carolina University.  Dave lives with his wife and three children in Austin, Texas.


John Weeg

  John Weeg has over 20 years of experience in information technology, starting as an application developer and progressing to his current level as an expert Oracle DBA. His focus for the past three years has been on performance, reliability, stability, and high availability of Oracle databases. Prior to this, he spent four years designing and creating data warehouses in Oracle.

John has a Bachelor of Science degree in Computer Science from the University of Iowa, and did post-Graduate work at Michigan State University.


Chris Foot

  Christopher T. Foot is an Oracle certified senior-level instructor, technical sales specialist and database architect.

He has fifteen years' experience with database Technologies and is a regular speaker at the International Oracle Users Group and Oracle Open World conferences Contemporary Technologies Inc. is a leading provider of Oracle products and services.



Mike Hordila

  Mike Hordila is a DBA OCP v.7, 8, 8i, 9i, and has his own Oracle consulting company, DBActions Inc., in Toronto, Ontario. He specializes in tuning, automation, security, and very large databases. Mike has articles in Oracle Magazine Online, Oracle Internals and He is also a technical editor with Hungry Minds (formerly IDG Books).


Table of Contents:


Section One - Datafiles

Chapter 1 - Measuring Oracle Segment I/O

What is Really Going On? by John Weeg


Test It

What Happens When We Update?

What Else?

So What?

Chapter 2 - Datafile Resizing Tips

Setting Free Your Space by John Weeg

Alter Database

Double Checking the Work

Chapter 3 - Reducing Disk I/O on Oracle Datafiles

Oracle Expert Tuning Secrets to reduce disk I/O by Don Burleson

Oracle tuning and Disk I/O

Tuning with RAM Data Buffers

The KEEP Pool

Locating Tables and Indexes for the KEEP Pool


Using Multiple Block Sizes

Disk I/O Tuning

STATSPACK Reports for Oracle Datafiles


Chapter 4 - Measuring Data Segment Statistics

Digging at the Segment Level : Performance Diagnosis Reaches A Deeper Level by Arup Nanda

Background / Overview

Setting the Statistics Levels

Segment Level Statistics Collection

Column Explanation

Examining Detailed Statistics


Case Study



Chapter 5 - Optimizing Oracle Physical Design

Optimal Physical Database Design for Oracle8i by Dave Ensor


Physical Database Design 101

What is Physical Database Design?

Database Block Structure

Block Size

Unstructured Data





Index Compression

Index Organized Tables (IOT's)

Insert Times

Retrieval Times

Application Impact

Online Table Reorganization

Temporary Tables

Application Impact

Locally Managed Tablespaces

Transportable Tablespaces


Chapter 6 - Verifying Segment Backup Scripts

Did the Backup Work? by John Weeg


How Do We Know?

Parsing This String

Bring It In

Use It

Use it Elsewhere

Chapter 7 - Data Segment Update Internals

How Much Does an Update Cost? by Jonathan Lewis

A Brief History of Screen Generators

What Does It Cost to Update a Column?

But There's More



Referential Integrity

There's Always a Trade-off


Chapter 8 - Segment Transaction Slot Internals

Interested Transaction List (ITL) Waits Demystified by Arup


What is ITL?

What Is an ITL Wait


How to Reduce ITL Waits

How to Diagnose the ITL Wait

What INITRANS Value is Optimal

Automatic Block Management in Oracle9i


Section Two - Tablespaces

Chapter 9 - Automated Space Cleanup in Oracle

Automated Space Cleanup in Oracle by Mike Hordila

Stray Temporary Segments

Manual Cleanup of Temporary Segments

Recommendations Regarding Temporary Segments


Problems with Rollback Segments

Recommendations Regarding Rollback Segments

Automated Space Cleanup


Overview of the Package


Chapter 10 - Using Oracle TEMP Files

Temporarily Yours: Tempfiles by John Weeg

Don't Wait to Create

Don't Backup

Don't Recover

Don't Copy for Standby

Don't Add Overhead

Give It a Try

Chapter 11 - Monitoring TEMP Space Usage

Who Took All the TEMP? by John Weeg

Where Are My TEMP Tablespaces?

Show Me the Objects

Who Are the Users?

A Happy Ending

Chapter 12 - Oracle9i Self-Management Features

Oracle9i Self-Management Features: The Early Winners by Dave Ensor


Test Environment




Instance Parameter Management

Self-Tuning Memory Management

Memory Made Simple

PGA Aggregate Target

Cache Advice

Automatic Undo Management


Rollback Segments

The Oracle9i Solution

Database Resource Manager

Unused Index Identification

Oracle Managed Files


Chapter 13 - Internals of Locally-Managed Tablespaces

Locally Managed Tablespaces by Jonathan Lewis

Tablespaces Past and Present

The Past

The Present

Where Are the Benefits?


Chapter 14 - Multiple Block Sizes in Oracle9i

Using Multiple Block Sizes in Oracle9i by Don Burleson

Indexes and Large Data Blocks

Allocating Objects into Multiple Block Buffers

Tools for Viewing Data Buffer Usage

Creating Separate Data Buffers




Section Three - Tables

Chapter 15 - Automated Table Reorganization in Oracle8i

Automated Table/Index Reorganization In Oracle8i by Mike Hordila

When Reorganizing, How Many Extents to Use?

Possible Reorganizing Strategies

Assumptions and Experimental Figures

Some Procedures Related to Table Reorganization

Important Issues Regarding Table/Index Moving/Rebuild

The Behavior of the "Alter Table/Index Move/Rebuild"


Limitations of the "ALTER TABLE MOVE" Command

Manual Object Reorganization

Step 1

Step 2

Automated Object Reorganization


Associated Tables

Overview of the Package


Chapter 16 - Using External Table in Oracle9i

External Tables in Oracle9i by Dave Moore




Practical Applications

Database Administration

Chapter 17 - Instructors Guide to External Tables

An Oracle Instructor's Guide to Oracle9i - External Tables by

Christopher Foot

External Tables

Tablespace Changes

Online Table Reorganizations

Index Monitoring

Section Four - Indexes

Chapter 18 - Using Locally-Managed Indexes

Locally Managed Indexes by John Weeg

Rebuild in the same Tablespace

No Fragment

81 to the Rescue

More Than One

What Goes Where

Break Points



Chapter 19 - Sizing Oracle Index Segments – Part 1

How Big Should This Index Be? by John Weeg

B-tree Theory

Estimate Leafs

Estimate Branches

Making the Index

Chapter 20 - Sizing Oracle Index Segments – Part 2

Is This Index the Right Size? by John Weeg

Validate Structure


Logical Steps for Resizing and Defragging

All Together Now

Section Five - Partitioning

Chapter 21 - Oracle Partitioning Design

Partitioning in Oracle 9i, Release 2 by Lisa Hernandez



Partitioning Defined

When To Partition

Different Methods of Partitioning

Partitioning Of Tables

Range Partitioning

Hash Partitioning

List Partitioning

Composite Range-Hash Partitioning

Composite Range-List Partitioning


Chapter 22 - Oracle Partitioning Design – Part 2

Partitioning in Oracle 9i, Release 2 -- Part 2 by Lisa Hernandez



Globally Partitioned Indexes

Locally Partitioned Indexes

When to Use Which Partitioning Method

Real Life Example


Chapter 23 - Effective Segment Partitioning – Part 1

Perils and Pitfalls in Partitioning — Part 1 by Arup Nanda

Plan Table Revisited


Partition Pruning or Elimination

Partition-wise Joins

Character Value in Range Partitioning

Chapter 24 - Effective Segment Partitioning – Part 2

Perils and Pitfalls in Partitioning — Part 2 by Arup Nanda

Multi-Column Partition Keys

Subpartition Statistics



Rule Based Optimizer

Coalesce vs Merge

Other Questions

What about Rebuild Partition and Global Indexes?

While using partitioning, should you use bind variables?

How many partitions can be defined on a table?

Section Six - Replication

Chapter 25 - Multi-Master Replication

A Four-phase Approach to Procedural Multi-master

Replication by Don Burleson


Why Consider Oracle Multi-master Replication?

Oracle Multi-master Replication

Multi-master Conflicts and Resolutions

Conflict Types

Conflict Resolution Mechanisms

Implementing Procedural Multi-master Replication

Phase I: Pre-configuration Steps for Multi-master Replication

Phase II: Set-up REPADMIN User and Database Links

Phase III: Create the Master Database and Refresh Groups

Phase IV: Monitoring Multi-master Replication

Resources for Defining Multi-master Replication



Chapter 26 - Replication Management

Automated Replication Management by Mike Hordila

Basic Replication

Automated Replication Management


Associated Tables

Overview of the Package


Test Environment

Chapter 27 - Replication Master Table

Altering the Master Table in a Snapshot Replication

Environment without Recreating the Snapshot by Arup Nanda


The Usual Method

The Alternative Approach

Detailed Steps






 Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks