Oracle Plug-in for Microsoft IIS Configuration and User's Guide Release 1.0.2 for Windows Part Number A87355-01 |
Library | Service | Contents | Index

# 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 `pluginiis` `PID``.trc` file is stored in the `\``ORACLE_BASE\ORACLE_HOME\``iisplugin` directory, where `iis` `PID` refers to the process ID of IIS.

If you require further assistance, contact Oracle Support Services.

| Copyright © 1996-2000 Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index