Skip Headers

Oracle9iAS Personalization Release Notes
Release 2 (v9.0.2) for UNIX

Part Number A95274-01
Go To Documentation Library

Oracle9iAS Personalization

Release Notes

Release 2 (v9.0.2) for UNIX

April 2002

Part No. A95274-01

These release notes describe Oracle9iAS Personalization, a product with the Oracle9i Application Server (Oracle9iAS). These notes present late-breaking information about the product and information about any new bugs. This document is organized as follows:

About Oracle9iAS Personalization 9.0.2

Oracle9iAS Personalization (OP) provides real-time personalization for Web sites using an integrated recommendation engine that is embedded in an Oracle database.

OP is based on data mining technology and modeling. It builds a predictive model of customer preferences using Web-based behavioral data collected by a Web site as well as demographic data.

The behavioral data OP collects can include customers' historical and current navigation and preferences, both stated and implied. OP then builds a model from the data collected (and stored in Oracle database tables) and makes real-time personalized recommendations based on the model.

Oracle9iAS Personalization consists of the following components:

OP includes an Administrative UI that is used to manage Oracle9iAS Personalization functions such as creating and managing recommendation engines and farms, creating and managing packages, scheduling builds and the deployment of packages, and scheduling reports.

The REAPI provides Java classes and methods you use to collect Web-based customer data and obtain recommendations.

What's New with Release 9.0.2

The following are new with Release 9.0.2:

Where to Find More Information

The documentation set for Oracle9iAS Personalization at the current release consists of the following documents:

Related Manuals

Oracle9iAS Personalization documentation is a component of the Oracle9i Application Server Documentation Library. See especially:


Documentation is provided in PDF and HTML formats.

To view the PDF files, you will need

To view the HTML files, you will need

Online Help

The Oracle9iAS Personalization Administrative UI includes online help, available by clicking the Help button in the upper right corner of each page of the Administrative UI.

For System Administrators

For technical support services, contact Customer Support at

Customer Database

Oracle9i Personalization requires a customer database in addition to the database included with Oracle9iAS. The customer database must be Oracle9i release 1.

Performance and Data Sizing

The table below shows the performance results on three datasets. The build time is linear in the number of customers and quadratic in the average profile size. We obtained the results shown here on a Sun Enterprise 450 (4 x UltraSPARC-II 400MHz) with 4096 megabytes of memory. Based on these numbers, it is possible to estimate the build time for any arbitrary dataset; see the subsection on Data Sizing, below. Definitions of the column headings follow the table.

Dataset # of Cust # of Items Avg. Profile Size Avg. Rating Profile Avg. Purch. Profile Avg. Nav. Profile Build Time # of Rules Agg. Model # of Rules Cross-Sell Model








1 min










3 min










5 min



The column headings have the following meanings:

MOR Temp Space

Use the following formula to calculate a rough estimate for the number of bytes of MOR temp space required:

where P is the average profile size and C is the number of customers. Each item pair generated during a build takes 54 bytes, which is the space needed to store a record with two item columns and a count column. For the model build to run, the available temp space should be more than the estimated temp space requirement for the P and C values of the dataset.

Bugs and Limitations

This section describes known bugs and limitations in Oracle9iAS Personalization release 9.0.2 as well as corrections to the documentation.

Correct Name of Product: The correct name of the product is "Oracle9iAS Personalization." In some instances the product may be incorrectly referred to as "Oracle9i Personalization."

Restrictions on Passwords: Because of password encryption and decryption, there are two restrictions on passwords for OP users:

RE Demo: Inconsistent Results: The results of Recommend Top Item and Recommend Bottom item are inconsistent. For example, if you request Recommend Top Item with a particular data set and get a particular result, and then repeat the process with the same data set, you may get a different result.

Sorting by ID and Sorting by Type Do Not Work: For both sessionful and sessionless REAPIs, for recommendation content, sorting by ID and sorting by Type do not work, whether "Ascend" or "Descend" is selected.

Native Character Sets Limitation: OP is certified against UTF8 only.

Bad Proxy Object Remains: When bad input data is entered in the REProxyManager.createProxy() method, an invalid proxy object can be created and remain in the pool. This can cause errors in later operations if you use the proxy. Workaround: Create a new proxy object using a different name. The bad proxy is harmless as long as you don't use it.

Advanced Button Brings Up "404 File Not Found" Message: This can happen with some versions of some browsers if user clicks Advanced button (at the bottom of the Log page) to bring up Message Viewer window if that window is still open (because user clicked Advanced button earlier and the window is still open).

REAPI Demo Bugs

REAPI Demo: Invalid JDBC URL Is Not Detected: REAPI Demo does not throw an exception when a bogus value is entered for JDBC URL.

REAPI Demo: Session ID Not Listed in Close Session Message: If, for example, you create a customer session with ID 13 and then close this session, the following message is displayed: "REAPI session of the user null closed successfully."

Documentation Correction

In the Oracle9iAS Administrator's Guide, chapter 7, page 7-2, step 4 should be followed by a new step 5, as follows:

and subsequent steps should be renumbered accordingly.

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

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.

Oracle is a registered trademark, and Oracle9i is a trademark or registered trademark of Oracle Corporation. Other names may be trademarks of their respective owners.

Copyright © 2002 Oracle Corporation.

All Rights Reserved.

Copyright © 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library