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"