Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

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