Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Overview

What's New in Version 9i

Oracle Enterprise Manager Console

Central Administration of Oracle Applications System

Automatic Problem Resolution

Oracle Applications Advanced Event Tests

Oracle Performance Manager

Oracle Capacity Planner

Concurrent Processing Tuning Assistant

Oracle Applications Manager

2 Post-Installation Configuration

Intelligent Agent on the Managed Node

Applying Oracle Applications Patch for Bug #1302931 or Bug #1371501

Configuring Windows NT Security for the Enterprise Manager Job System

Enabling Disk Statistics Collection for Capacity Planner and Performance Manager on Windows NT

Configuring Oracle Applications Sign-On Auditing

Starting the Intelligent Agent on the Managed Node

Managing the Intelligent Agent on UNIX

Managing the Intelligent Agent on Windows NT

Managing the Intelligent Agent from the Windows NT Command Prompt

Oracle Management Server (OMS)

Creating the Oracle Management Server Repository

Starting the Oracle Management Server

Managing the Oracle Management Server on UNIX

Managing the Oracle Management Server on Windows NT

Using CPTA Through the Oracle Management Server

Running the Management Pack for Oracle Applications through a Web Browser

Oracle Enterprise Manager Console

Starting the Oracle Enterprise Manager Console

Discovering Nodes and Services

Configuring the oapps.ora File on the Concurrent Manager Node

Discovering Concurrent Managers in the Console

Setting Preferred Credentials

Starting Applications in the Management Pack for Oracle Applications

Configuration Checklist

3 Introduction to Oracle Performance Manager

Accessing Performance Data Through an Intermediate Host

Usage Scenarios for Oracle Performance Manager

Starting Oracle Performance Manager

Starting Oracle Performance Manager from the Console

Starting Oracle Performance Manager from the UNIX Command Line

Starting Oracle Performance Manager from the Start Menu in Windows NT

Running Performance Manager in Enterprise Mode

Running Performance Manager in Standalone Mode

Using the Oracle Performance Manager Main Window

Connecting to a Discovered Target in Enterprise Mode

Manually Connecting to a Target

Viewing Performance Manager Charts

Monitoring Multiple Targets Concurrently

Viewing Chart Groups

Selecting Collected Data and Data Sources

Using the Chart Display Window

Selecting a Chart Format

Setting the Chart Refresh Rate

Pausing and Restarting a Chart

Selecting Chart Options

Chart-Specific Commands

Drilling Down from One Chart to Another

Using the Chart Status Button

Drilling Down to an Historical Chart

Displaying Alternate Chart Orientations

Sorting Data in a Table Chart

Saving Your Changes to a Chart

Obtaining Help for a Class, Chart, or Data Item

Printing a Chart

Generating a Report for a Chart

Recording Chart Data

Starting a Recording

Stopping a Recording

Playing a Recording

Removing a Recording

Chart Display Window Menu Shortcut Keys

Working With Events and Thresholds in Performance Manager

Triggered Events and Thresholds

Events Registered for Multiple Targets

Metrics with Multiple Events and Different Thresholds

Event Permissions

Registering Events in Performance Manager

About Oracle 9i and Pre-9i Agents

Viewing Thresholds

Resetting Thresholds

Refreshing Thresholds

Editing Threshold Associations

Running Performance Manager in a Browser

Viewing Metric and Event Documentation Through a Browser

4 Introduction to Oracle Capacity Planner

How Capacity Planner Collects and Stores Performance Data

Accessing Historical Data Through an Intermediate Host

Usage Scenarios for Oracle Capacity Planner

Starting Oracle Capacity Planner

Using Help

Using Oracle Capacity Planner

Setting Up a Collection

Selecting Targets

Selecting Targets on Discovered Nodes

Selecting Targets on Undiscovered Nodes

About the Target Property Sheet

Defining the Frequency of Collection Samples

Defining the Location of the Historical Database

Defining the Frequency of Loading Collection Data

Understanding When the Loader Runs

Understanding How Data Aggregation Works

Defining the Amount of Data to Keep

Applying and Reverting the Collection Settings for a Target

Selecting the Classes of Data to Collect

Starting Data Collection

Stopping Data Collection

Generating a Collection Report

Copying Collection Settings

Troubleshooting Collection and Load Problems

Analyzing Collected Data

Connecting to an Oracle Capacity Planner Historical Database

Organization of Data in the Navigator

Browsing the Collected Data

Viewing an Analysis for a Class of Data

Saving a Class Analysis as a User-Defined Analysis

Specifying Selection Criteria for a Class of Data

Viewing and Modifying User-Defined and Predefined Analyses

Creating a Copy of an Analysis

Renaming a User-Defined Analysis

Deleting a User-Defined Analysis

Working with Analyses

Viewing the Value of a Data Point

Selecting a Line

Adding a Class of Data to an Analysis

Modifying Selection Criteria from the Analysis Window

Removing a Line from a Chart

Excluding a Data Point from a Chart

Showing or Hiding the Chart Legend

Zooming and Scrolling to View More or Less Chart Data

Auto-Scaling Data

What Is a Trend Analysis?

Specifying and Performing a Trend Analysis

Saving Changes to a User-Defined or Predefined Analysis

Saving the Results of a User-Defined Analysis

Saving the Results of a Predefined Analysis

Printing an Analysis Chart

Generating a Report for an Analysis Chart

Understanding the Oracle Capacity Planner Historical Database

Understanding the Service Reference Table (vp_service_ref)

Understanding the Class Reference Table (vp_class_ref)

Understanding the Data Tables

Data Table Names

Data Table Contents

5 Concurrent Processing Tuning Assistant

Considerations When Using the Tuning Assistant

Connecting Directly to the Applications Database

Connecting to the Concurrent Processing Tuning Assistant Repository

Usage Scenarios for the Tuning Assistant

Concurrent Manager Balancing

Concurrent Manager Specialization

Starting the Tuning Assistant

Starting the Tuning Assistant from Oracle Enterprise Manager

Starting the Tuning Assistant from the UNIX Command Line

Starting the Tuning Assistant from the Start Menu on Windows NT

Using the Tuning Assistant

Tuning Assistant Main Window

General Tab

Options Tab

Displaying Reports

Saving Reports

Report Properties

Drill Down from Tuning Assistant Reports

Printing Tuning Assistant Reports

Report Descriptions

Concurrent Managers by Hour (24x7)

Concurrent Manager Usage by Program

Program Run Summary by Status

Program Wait Summary

Waiting Requests by Hour (24x7)

Long Running Requests

Short Running Requests that Waited

Request Run Summary by Month

Drill-Down Reports

Requests that Ran

Requests that Waited

Request Details

Tuning Advisor

Tuning Advisor Reports

Tuning Advisor Report

Tuning Suggestion Report for High Utilization with Many Waiting Requests

Tuning Suggestion Report for Low Utilization with Many Waiting Requests

Tuning Suggestion Report for No Capacity with Many Waiting Requests

6 Oracle Applications Advanced Event Tests

Fault Event Tests

Concurrent Manager UpDown

CRM Waiting on a Lock

ICM Waiting on a Lock

Request Error Rate

Request Warning Rate

Unresponsive Concurrent Manager

Performance Event Tests

Inactive Request Pending

Pending Concurrent Request Backlog

Request Pending Time

Run Alone Request Submitted

Space Event Tests

Concurrent Manager Disk Free

Fault Event Tests (For V8.1.6 and Earlier Agents)

Concurrent Manager UpDown (for V8.1.6 and Earlier Agents)

CRM Waiting on a Lock (for V8.1.6 and Earlier Agents)

ICM Waiting on a Lock (for V8.1.6 and Earlier Agents)

Request Error Rate (for V8.1.6 and Earlier Agents)

Request Warning Rate (for V8.1.6 and Earlier Agents)

Performance Event Tests (For V8.1.6 and Earlier Agents)

Inactive Request Pending (for V8.1.6 and Earlier Agents)

Pending Concurrent Request Backlog (for V8.1.6 and Earlier Agents)

Request Pending Time (for V8.1.6 and Earlier Agents)

Run Alone Request Submitted (for V8.1.6 and Earlier Agents)

7 Oracle Applications Jobs

Setting Concurrent Manager Node Credentials

Job Descriptions

Concurrent Manager Shutdown

Concurrent Manager Shutdown (for V8.1.6 and Earlier Agents)

Concurrent Manager Startup

Concurrent Manager Startup (for V8.1.6 and Earlier Agents)

Kill Locking Session

Kill Locking Session (for V8.1.6 and Earlier Agents)

Load Data into Concurrent Processing Tuning Assistant

A Troubleshooting

Managed Node (Concurrent Manager Node)

Cannot Start the Intelligent Agent - Oracle Performance Utility Conflict

Oracle Management Server Node (OMS)

Problems Connecting to Oracle Management Server

Client Node

Unable to Connect to Repository When Using Performance Manager or Capacity Planner

Unable to Start Performance Manager in Context of the Console

Error Connecting to Repository When Using Performance Manager

Cannot Save Current Performance Manager Work

Errors Occur When Attempting to Connect to Oracle Applications Instances

Losing Connection to a Service

Version of Agent Is Not Compatible with Event or Job

Advanced Events Do Not Display in the Browser

'Failed to Authenticate User Error' When Running a Job

Multiple Instances of the Same Concurrent Managers in the Console

Chart Recording Stops When Enterprise Manager Console Is Closed

Index