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

Index Performance Considerations

Locking

In This Chapter

Locks

Configuring Lock Mode

Lock Waits

Locks with the SELECT Statement

Locks Placed with INSERT, UPDATE, and DELETE

Monitoring and Administering Locks

Monitoring Locks

Configuring and Monitoring the Number of Locks

Monitoring Lock Waits and Lock Errors

Monitoring Deadlocks

Monitoring Isolation That Sessions Use

Locks for Smart Large Objects

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