Contents

Title and Copyright Information

Send Us Your Comments

Preface

Related Documentation

Documentation Accessibility

Conventions

Oracle Services and Support

1 Understanding mod_plsql

1.1 Processing C lient Requests

1.2 Database Access Descriptors (DADs)

1.3 Invoking mod_plsql

1.4 Transaction Mo de

1.5 Supported Data Types

1.6 Parameter Passing

1.6.1 Parameter Passing by Nam e (Overloaded Parameters)

1.6.2 Flexible Parameter Passing

1.6.2.1 Two Parameter Interface

1.6.2.2 Four Parameter Interface

1.6.3 Large Parameter Passing

1.7 File Upload and Download

1.7.1 Document Table Definition

1.7.1.1 Semantics of the CONTENT Column

1.7.1.2 Semantics of t he CONTENT_TYPE Column

1.7.1.3 Semantics of the LAST_UPDATED Column

1.7.1.4 Semantics of the DAD_CHARSET Column

1.7.2 Old Style Document Table Definition

1.7.3 C onfiguration Parameters for Document Upload/Downloading

1.7.3 .1 PlsqlDocumentTablename

1.7.3.2 PlsqlDocumentPath (Document Access Path)

1.7.3.3 PlsqlDocumentProcedure (Document Access Procedure)

1.7.3.4 PlsqlUploadAsLongRaw

1.7.4 File Upload

1.7.5 Specifying Attributes (Mime Types) of Uploaded Fil es

1.7.6 Uploading Multiple Files

1.7.7 File Download

1.7.8 Direct BLOB Download

< /dd>

1.8 Path Aliasing (Direct Access URLs)

1.9 Common Gateway Interface (CGI) Environment Variables

1.9.1 Adding and Overriding CGI Environment Variables

1.9.2 Plsq lNLSLanguage

1.9.2.1 REQUEST_CHARSET CGI Environment Variable

1.9.2.2 REQUEST_IANA_CHARSET CGI Environment Variable

1.10 Restrictions in mod_plsql

2 Configuring mod_plsql

2.1 Verifying Requirements

2.2 Installing Requi red Packages

2.3 Creating a DAD for Your PL/SQL Application

3 Securing Application Database Access Throug h mod_plsql

3.1 Authenticating Users Through mod_pl sql

3.1.1 Basic (Database Controlled Authentication)

3.1.2 Oracle HTTP Server mod_plsql Basic Authentication Mode

3.1.3 Global OWA, Custom OWA, and Per Package (Custom Authentication)

3.2 Deauthenticating Users

3.3 Protecting t he PL/SQL Procedures Granted to PUBLIC

3.3.1 Using the PlsqlEx clusionList Directive in mod_plsql

3.3.2 Accessing the PlsqlExclusionList Dir ective

4 Optimi zing PL/SQL Performance

4.1 PL/SQL Performance in Oracle HTTP Server - Overview

4.2 Process-Based and Thread-Based Operation in Oracle HTTP Server

4.3 Performance Tuning Issues for mod_plsql

4.3.1 Connection Pooling with mod_plsql

< a href="optplsql.htm#1021343">4.3.2 Closing Pooled Database Sessions

4.3.3 Restarting the mod_plsql Connection Pool

4.4 Performance Tuning A reas in mod_plsql

4.4.1 PL/SQL Based Web Application Develop ment Considerations

4.4.2 Connection Pooling Tips and Oracle HTTP Server Co nfiguration

4.4.3 Tuning the Number of Database Sessions

4.4.4 Two-Listener Strategy

4.4.5 O verhead Problems

4.4.5.1 The Describe Overhead

4.4.5.2 Avoiding the Describe Overhead

4.4.6 The Flexible Parameter Passing (four-parameter) Overhead

4.5 Using Caching with PL/SQL Based Web Applications

4.5.1 Using the Validation Technique

4.5.1.1 Last- Modified

4.5.1.2 Entity Tag Method

4.5.1.3 Using the Validation Technique for mod_plsql

4.5. 1.4 Second Request Using the Validation Technique

4.5.2 Using the Expires Technique

4.5.3 System- and User-level Caching with PL/SQL Based W eb Applications

4.6 Tuning File System Cache to Improve Caching P erformance

4.6.1 Introducing File System Cache Tuning

4.6.2 Enabling File System Cache

4.6.3 Configuring File System Cache to Reside on a Faster File System

4.6.4 Resizing File System Cache

4.6.4.1 Setting the To tal Cache Size with PlsqlCacheTotalSize

4.6.4.2 Setting the Days of Aging f or Cache with PlsqlCacheMaxAge

4.6.4.3 Setting the Maximum File Size for a Cache File with PlsqlCacheMaxSize

4.6.5 Configuring Cache Cleanup

4.7 Oracle HTTP Server Directives

A Frequently Asked Questions

Index