Home | Previous Page | Next Page

Tuning Configuration for Resource Usage

In This Chapter

Tuning CPU-Management Parameters

Ensuring High Priority for Database Server Processes

Tuning Virtual Processors That Manage I/O

Using AIO Virtual Processors With KAIO

Using Only AIO Virtual Processors

Specifying the Number of FIFO Virtual Processors

Tuning Virtual Processors to Manage Network Poll Threads

Tuning Memory-Management Parameters

Managing Basic Memory Configuration Parameters

Enforcing Shared-Memory Residence

Setting the Initial Size of the Virtual Portion of Shared Memory

Tuning the Size of Each Virtual-Memory Increment

Managing Data Buffers

Tuning BUFFERS to Improve the Read-Cache Rate

Tuning the Data-Dictionary Cache

Setting the Initial Number of Concurrent Locks

Specifying Shared Memory for Log Buffers

The Logical-Log Buffer Size

The Physical-Log Buffer Size

Allocating Memory for DSS Queries

Specifying the Maximum Amount of Memory Available for Queries

Managing Memory Allocation for a Single Query

Tuning I/O-Management Parameters for Queries and Transactions

Managing Temporary Space

Temporary Space Guidelines

Estimating Required Temporary Space

Creating Dbslices for Temporary Tables and Sort Files

Specifying Temporary Space Availability

Limiting Temporary Space for Individual Query Overflow

Managing Parameters for Table and Index I/O

Specifying the Maximum Number of Locked Rows for Each Scan

Tuning Read-Ahead Behavior

Specifying Spaces that Can Be Skipped if Not Available

Tuning Background-Process Parameters

Managing Background Processes

Managing Checkpoints

Specifying the Interval Between Checkpoints

Specifying the Number of Least Recently Used Queues

Tuning Write-Cache Rates

Specifying the Number of Checkpoint Page Cleaner Threads

Managing the Logical Log

Estimating the Size of the Logical Log

Specifying the Size and Number of Logical Log Files

Managing Long Transactions in the Logical Log

Managing the Physical Log

Specifying Logical Recovery Configuration Parameters

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]