Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Documentation Accessibility

Related Documents

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.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 Using Caching with PL/SQL Based Web Applications

1.10.1 Using the Validation Technique

1.10.1.1 Last-Modified

1.10.1.2 Entity Tag Method

1.10.1.3 Using the Validation Technique for mod_plsql

1.10.1.4 Second Request Using the Validation Technique

1.10.2 Using the Expires Technique

1.10.3 System- and User-level Caching with PL/SQL Based Web Applications

1.11 Performance Tuning Areas for mod_plsql

1.11.1 Connection Pooling with mod_plsql

1.11.2 Closing Pooled Database Sessions

1.11.3 Detecting Dead Database Connections in a Connection Pool

1.11.3.1 Specifying the Option to Detect Dead Database Connections

1.11.3.2 Specifying the Timeout Period

1.12 Restrictions in mod_plsql

2 Configuring mod_plsql

2.1 Verifying Requirements

2.2 Installing Required Packages

2.3 Accessing the mod_plsql Configuration Page

2.3.1 Access the DAD Configuration Pages Through Oracle Enterprise Manager 10g

2.3.2 Access the DAD Configuration Pages Through Portal

2.4 Configuring mod_plsql for Use with OracleAS Portal 3.0.9

2.5 Creating a DAD for Your PL/SQL Application

3 Securing Application Database Access Through mod_plsql

3.1 Security Considerations

3.1.1 Defining the PlsqlRequestValidationFunction Directive in mod_plsql

3.1.2 Adding More Rules to the PlsqlExclusionList Directive in mod_plsql

3.1.3 Using the AUTHORIZE Procedure in Custom Authentication

3.1.4 Protecting Database Tables

3.2 Authenticating Users Through mod_plsql

3.2.1 Basic (Database Controlled Authentication)

3.2.2 Oracle HTTP Server mod_plsql Basic Authentication Mode

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

3.3 Deauthenticating Users

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 in mod_plsql

4.3.1 PL/SQL Based Web Application Development Considerations and Programming Tips

4.3.2 Connection Pooling Tips and Oracle HTTP Server Configuration

4.3.3 Tuning the Number of Database Sessions

4.3.4 Two-Listener Strategy

4.3.5 Overhead Problems

4.3.5.1 The Describe Overhead

4.3.5.2 Avoiding the Describe Overhead

4.3.6 The Flexible Parameter Passing (four-parameter) Overhead

4.4 Tuning File System Cache to Improve Caching Performance

4.4.1 Introducing File System Cache Tuning

4.4.2 Enabling File System Cache

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

4.4.4 Configuring Session Cache Using Performant File System (OracleAS Portal Only)

4.4.5 Resizing File System Cache

4.4.5.1 Setting the Total Cache Size with PlsqlCacheTotalSize

4.4.5.2 Setting the Days of Aging for Cache with PlsqlCacheMaxAge

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

4.4.6 Configuring Cache Cleanup

4.5 Oracle HTTP Server Directives

A Frequently Asked Questions

Index