Preface

This manual describes how to install, configure, and maintain mod_plsql for Oracle Application Server 10g (9.0.4). It contains the following chapters:

• Chapter 1 - Provides an overview of the mod_plsql and its features.

• Chapter 2 - Explains how to use mod_plsql.

• Chapter 3 - Describes how to secure the database and PL/SQL using mod_plsql.

• Appendix A - Frequently Asked Questions

New Features

• Enhanced cache clean up algorithm allowing users to configure the time to clean up cache.

• Enhanced OWA packages to allow better byte-packing of response data from multi-byte databases resulting in lesser round-trips to the database

• Reduced PL/SQL function call overheads in heavily called OWA package APIs like htp.p.

• Enhanced performance logging in mod_plsql. See "What kind of logging facilities are available in mod_plsql?" in Appendix A, "Frequently Asked Questions" for more information.

• Enhanced security by obscuring schema passwords in the DAD configuration.

• Integration with Enterprise Manager for log analysis and log correlation.

  See Also: Oracle Application Server 10g Administrator's Guide

• Dropped requirement to have /pls in the virtual path for accessing mod_plsql. It can still be used, but is no longer required. mod_plsql has been integrated in the Oracle HTTP Server configuration since release 9.0.x, and therefore, it no longer has any dependency on having "/pls/DAD" as the entry point for mod_plsql. Note that OracleAS Portal DADs still need to be of the format /pls/dad.

Related Documentation

You may also find the following manuals in the Oracle Application Server documentation set useful:

Title	Containing Information about...
Oracle HTTP Server Administrator's Guide	Oracle HTTP Server Modules - Administration using the command line tools and manually editing configuration files (DAD parameters, http.conf etc.)
Oracle Application Server 10g Performance Guide	Performance and tuning material and caching
Oracle Application Server 10g Administrator's Guide	Administering Oracle Application Server through the Oracle Enterprise Manager Console (DAD Configuration)
Oracle Application Server 10g Upgrading to 10g (9.0.4)	Parameters that have changed and tools used to migrate DADs
Oracle Application Server 10g PL/SQL Web Toolkit Reference	OWA package information
Oracle Application Server 10g Installation Guide	Installation for the Oracle Application Server
Oracle Application Server 10g Migrating from Oracle Application Server	Migrating from previous versions (Oracle Application Server)
Oracle Application Server 10g Concepts	Overview of the Oracle Application Server

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Standards will continue to evolve over time, and Oracle Corporation is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For additional information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.

Accessibility of Code Examples in Documentation

JAWS, a Windows screen reader, may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, JAWS may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle Corporation does not own or control. Oracle Corporation neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Conventions

The following conventions are used in this manual:

Convention	Meaning
. . .	Vertical ellipsis points in an example mean that information not directly related to the example has been omitted.
. . .	Horizontal ellipsis points in statements or commands mean that parts of the statement or command not directly related to the example have been omitted
boldface text	Boldface type in text indicates a term defined in the text.
< >	Angle brackets enclose user-supplied names.
[ ]	Brackets enclose optional clauses from which you can choose one or none.

Oracle Services and Support

Information about Oracle products and global services is available from:

http://www.oracle.com 

The sections below provide URLs for selected services.

Oracle Technology Network

Register with the Oracle Technology Network (OTN) at:

http://otn.oracle.com 

OTN delivers technical papers, discussion forums, code samples, product documentation, self-service developer support, and Oracle key developer products to enable rapid development and deployment of application built on Oracle technology.

Oracle Support Services

Technical Support contact information worldwide is listed at:

http://www.oracle.com/support

Templates are provided to help you prepare information about your problem before you call. You will also need your CSI number (if applicable) or complete contact details, including any special project information.

Product and Documentation

For U.S.A customers, Oracle Store is at:

http://store.oracle.com 

Links to Stores in other countries are provided from this site.

Product documentation can be found at:

http://docs.oracle.com

Customer Service

Global Customer Service contacts are listed at:

http://www.oracle.com/support 

Education and Training

Training information and worldwide schedules are available from:

http://education.oracle.com