Preface

This manual describes how to install, configure, and maintain mod_plsql. It contains the following chapters:

Chapter 1, "Understanding mod_plsql" provides an overview of mod_plsql and its features.
Chapter 2, "Configuring mod_plsql" explains how to use mod_plsql.
Chapter 3, "Securing Application Database Access Through mod_plsql" describes how to secure the database access using mod_plsql.
Chapter 4, "Optimizing PL/SQL Performance" describes how to optimize PL/SQL performance.
Appendix A, "Frequently Asked Questions" contains the answers to frequently asked questions.

New Features

New features in this release of mod_plsql include:

Enhanced cache clean up algorithm allowing users to configure the time to clean up the cache.
Enhanced OWA packages to allow better byte-packing of response data from multibyte databases resulting in fewer 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 kinds 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.
Removed the 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 and so a mod_plsql URL no longer needs to start with a "/pls" prefix.

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 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 does not own or control. Oracle 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 subsequent sections provide URLs for selected services.

Oracle Technology Network

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