Oracle9i Application Server Using the PL/SQL Gateway
Release 1 (v1.0.2.2)
Part Number A90099-01

A
Performance Tuning

This chapter describes several techniques to improve the performance of your PL/SQL application. Go through the worksheet to see if your systems are working to their maximum potential.

Table 6-2 Performance Tuning Worksheet

Parameters and Settings	Recommendations	Refer to:
DAD parameters
Response Array Size	Default = 128 Japanese, Chinese or Multi-byte Character set languages =Adjust parameter to 256	Accessing Database Access Descriptor settings
Keep Database Connection Open Between Requests	Yes=maximum performance No = Debugging	Accessing Database Access Descriptor settings Controlling Database Processes for Each mod_plsql Request
Oracle HTTP Server powered by Apache Settings
mod_expires	Use to cache in the browser.	mod_expires Refer to www.apache.org for Apache specific information.
KeepAlive directives	Adjust defaults to improve performance. KeepAlive=On MaxKeepAliveRequest=100 KeepAliveTimeout=15	KeepAlive Directives Refer to www.apache.org for Apache specific information.
Apache Processes configuration	Adjust defaults to improve performance: MaxRequests=MaxSpareServers MaxRequestsPerchild=HighNumber MinSpareServers=0	"Controlling Database Processes for Each mod_plsql Request". Refer to www.apache.org for Apache specific information.
Caching
Expires Technique	Best performance (for content that changes predictably)	Using the Expires Technique
Validation technique	Good performance (for content that changes unpredictably)	Validation Technique
System-level caching	Improves performance by caching one copy for everyone on system	System- and User-level Caching

Oracle

Copyright © 2001 Oracle Corporation.
All Rights Reserved.