Introduction

Performance Basics

Performance Monitoring and the Tools You Use

Effect of Configuration on CPU Utilization

Effect of Configuration on Memory Utilization

Effect of Configuration on I/O Activity

Table Performance Considerations

In This Chapter

Placing Tables on Disk

Isolating High-Use Tables

Placing High-Use Tables on Middle Partitions of Disks

Using Multiple Disks

Backup-and-Restore Considerations

Improving Performance for Nonfragmented Tables and Table Fragments

Estimating Table Size

Managing the Size of First and Next Extents for the tblspace tblspace

Managing Sbspaces

Managing Extents

Changing Tables

Denormalizing the Data Model to Improve Performance

Index Performance Considerations

Locking

Fragmentation Guidelines

Queries and the Query Optimizer

Optimizer Directives

Parallel Database Query

Improving Individual Query Performance

The onperf Utility on UNIX

Appendix A. Case Studies and Examples

Appendix B. Accessibility

Notices

Index