Contents

Challenges

1. Performance Challenges

Block Fragmentation

High Water Mark Effect

Inappropriate PCTFREE and PCTUSED Settings

Row Chaining

Stagnated Indexes

Data Partitioning

2. The Availability Challenge

3. The Capacity Challenge

Wasted Space in Tablespaces

Wasted Space Due to Too Many Extents

Wasted Space in Locally Managed Tablespaces

Locally Managed Tablespace Autoallocate

The Solution:Space Manager with LiveReorg®

1. Problem Detection

Tablespace Maps

Exception Reports

Predicted Reorganization Benefit Report

2. Reorganization

Table Reorganization

Table Reorganization Methods

LONG and LONG RAW Tables

Partitioned Objects

Index Reorganization

Tablespace Reorganization

Option #1: Reorganize a Tablespace in Place

Option #2: Reorganize a Tablespace Using External Space

Option #3: Full Tablespace Defragmentation

Sorted Reorganizations

Fast, Flexible Reorganizations

Speed

Flexibility

Restructure/Relocate Reorganizations

SAP Tables

3. Monitoring Scripts

Job Monitoring

Job Alerts

4. Capacity Planning

Tracking Space Usage

Trending Space Usage

5. SAP Considerations

Managing the Time of Switch of the T-LOCK Method

The Importance of a TEMPORARY Tablespace

Using Locally Managed Tablespaces

Automatic Segment Space Management (ASSM)

Relocating Objects

Heavy Loaded Systems

Reorg or Not to Reorg

Conclusion

Appendix: SAP Evaluation

About the Author

About Quest Software, Inc.

Contacting Quest Software

Contacting Quest Support

Oracle Whitepapers - Improve Performance in SAP Application Environments with Space Manager with LiveReorg Index