3
How to Use Oracle Plug-in for Microsoft IIS

This chapter describes how to create Web components and trace component requests.

This chapter contains these topics:

• Creating Web Components

• Invoking Web Components

• Performance Tuning

• Creating a Trace File

Creating Web Components

PL/SQL Web components are PL/SQL stored procedures written using the PL/SQL Web Toolkit and PL/SQL Server Pages.

Java Web Components are JavaServer Pages and Java Servlets.

For Information About...	See...
Installing the PL/SQL Web Toolkit	Using the PL/SQL Gateway
Using the PL/SQL Web Toolkit	Using the PL/SQL Gateway
Creating and Loading PL/SQL stored procedures into the database	Using the PL/SQL Gateway
PL/SQL Gateway Tutorial	Using the PL/SQL Gateway
Developing PL/SQL stored procedures and PL/SQL Server Pages	Oracle8i Application Developer's Guide - Fundamentals This manual is available from OTN. See "Related Documentation" for information on how to access OTN.
Running Java in the database	Oracle8i Java Developer's Guide
Writing, installing, and deploying Java applications within the database	Oracle8i Java Developer's Guide
Creating and running JSPs in the Oracle Servlet Engine	Oracle JavaServer Pages Developer's Guide and Reference
Publishing and invoking JSPs and Servlets in the Oracle Servlet Engine. Overview of Session Shell Tool commands and mapping virtual paths.	Oracle8i Oracle Servlet Engine User's Guide
Session Shell Tool commands	Oracle8i Java Tools Reference

Invoking Web Components

This section provides information about the following:

• Invoking PL/SQL Web Components

• Invoking Java Web Components

Invoking PL/SQL Web Components

To invoke PL/SQL Web components in a Web browser, the URL is typically in the following format:

protocol://hostname[:port]/prefix/DAD/[[!][schema.][package.]
proc_name[?query_string]]

Where...	Specifies...
protocol	Either http or https. For SSL, use https.
hostname	The computer where IIS is running.
port	The port at which the IIS is listening for Web components. If omitted, port 80 is assumed.
prefix	The virtual path mapped to Oracle Plug-in for Microsoft IIS. This setting must be pls
DAD	The DAD entry to be used for this URL.
schema	The database schema name. If omitted, name resolution for package.proc_name occurs based on the database user that the URL request is processed as.
package	The package that contains the PL/SQL stored procedure. If omitted, the procedure is stand alone.
proc_name	The PL/SQL stored procedure to run. This must be a procedure and not a function.
?query_string	The parameters for the stored procedure. The string follows the format of the GET method.

Invoking Java Web Components

To invoke Java Web components in a Web browser, the URL is typically in the following format:

http://hostname[:port]/servlet-context/a.snoop

Where...	Specifies...
hostname	The computer where IIS is running.
port	The port at which IIS is listening for HTTP requests. If omitted, port 80 is assumed.
servlet-context	The virtual path where the Java Web components are stored inside the Oracle database.
a.snoop	The Java servlet to execute.

Performance Tuning

Under a heavy load, performance may improve by fine tuning the individual Web component configurations. For Java components, increase the number of Maxworkers in your Java configuration file. For PL/SQL components, change the Connection Pool Parameters from the Edit Database Access Descriptor Web page.

See Also: "Setting the Maxworkers Parameter" to set the Maxworkers parameter Using the PL/SQL Gateway for more information about the Edit Database Access Descriptor Web page

Setting the Maxworkers Parameter

Optionally, add the Maxworkers parameter to the Java configuration file to increase Java Web component performance of concurrent requests handled by the OSE server. Figure 2-2 implements the Maxworkers parameter. The default number of Maxworkers is 50.

Creating a Trace File

Oracle Plug-in for Microsoft IIS Trace option allows you to collect data about all the Oracle Plug-in for Microsoft IIS transactions executing against a database. The trace file shows HTTP requests and responses. Use any text editor to view the trace file.

To set the Trace option, perform the following steps:

1. From the Windows Registry Editor, right-click HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE and select New > DWORD Value.

2. Enter ORA_IISPLUGIN_TRACE as the Value Name.

3. Right-click ORA_IISPLUGIN_TRACE and select Modify.

4. To turn the Trace option on, enter 1 as the Value data.

   When tracing is enabled, the pluginiisPID.trc file is stored in the \ORACLE_BASE\ORACLE_HOME\iisplugin directory, where iisPID refers to the process ID of IIS.

If you require further assistance, contact Oracle Support Services.