Introduction

Performance Basics

Performance Monitoring and the Tools You Use

Effect of Configuration on CPU Utilization

Effect of Configuration on Memory Utilization

In This Chapter

Allocating Shared Memory

Configuring UNIX Shared Memory

Freeing Shared Memory with onmode -F

Configuration Parameters That Affect Memory Utilization

Setting the Size of the Buffer Pool, Logical-Log Buffer, and Physical-Log Buffer

LOCKS

RESIDENT

SHMADD

SHMTOTAL

SHMVIRTSIZE

STACKSIZE

Parameters That Affect Memory Caches

SQL Statement Cache

Session Memory

Data-Replication Buffers and Memory Utilization

Memory Latches

Encrypted Values

Effect of Configuration on I/O Activity

Table Performance Considerations

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