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 Client Requests

1.2 Database Access Descriptors (DADs)

1.3 Invoking mod_plsql

1.4 Transaction Mode

1.5 Supported Data Types

1.6 Parameter Passing

1.6.1 Parameter Passing by Name (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 the 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 Configuration 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 Files

1.7.6 Uploading Multiple Files

1.7.7 File Download

1.7.8 Direct BLOB Download

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 PlsqlNLSLanguage

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 Required Packages

2.3 Creating a DAD for Your PL/SQL Application

3 Securing Application Database Access Through mod_plsql

3.1 Authenticating Users Through mod_plsql

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 the PL/SQL Procedures Granted to PUBLIC

3.3.1 Using the PlsqlExclusionList Directive in mod_plsql

3.3.2 Accessing the PlsqlExclusionList Directive

4 Optimizing 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

4.3.2 Closing Pooled Database Sessions

4.3.3 Restarting the mod_plsql Connection Pool

4.4 Performance Tuning Areas in mod_plsql

4.4.1 PL/SQL Based Web Application Development Considerations

4.4.2 Connection Pooling Tips and Oracle HTTP Server Configuration

4.4.3 Tuning the Number of Database Sessions

4.4.4 Two-Listener Strategy

4.4.5 Overhead 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 Web Applications

4.6 Tuning File System Cache to Improve Caching Performance

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 Total Cache Size with PlsqlCacheTotalSize

4.6.4.2 Setting the Days of Aging for 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