Oracle® Enterprise Manager

Oracle Application Management Pack for Oracle E-Business Suite Metric Reference Manual

12c Release 4 (12.1.0.4)

E54435-03

February 2016

Oracle Enterprise Manager Oracle Application Management Pack for Oracle E-Business Suite Metric Reference Manual 12c Release 4 (12.1.0.4)

E54435-03

Copyright © 2014, 2016, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Contents

Preface

- Audience

- Documentation Accessibility

- Related Documents

- Conventions

What's Changed in this Guide?

How to Use This Manual

- Structure of This Manual

- Background Information on Metrics, Thresholds, and Alerts

- Troubleshooting Metrics

1 Custom Oracle Concurrent Manager

- 1.1 Active Processes

- 1.1.1 OS Process ID

- 1.1.2 Process Status

- 1.1.3 Session Id

- 1.1.4 Target Node

- 1.2 Capacity Utilization of Concurrent Managers

- 1.2.1 Manager Name

- 1.2.2 Utilized Capacity

- 1.3 Concurrent Requests in Blocked State

- 1.3.1 Blocking Action

- 1.3.2 Blocking Id

- 1.3.3 Blocking Inst. ID

- 1.3.4 Blocking Minutes

- 1.3.5 Blocking Module

- 1.3.6 Concurrent Program Name

- 1.3.7 Concurrent Request Inst. Id

- 1.3.8 Concurrent Request SID

- 1.3.9 Request Id

- 1.4 Concurrent Requests by Status

- 1.4.1 Concurrent Requests Inactive (On Hold)

- 1.4.2 Concurrent Requests Pending (Normal)

- 1.4.3 Concurrent Requests Pending (Standby)

- 1.4.4 Concurrent Requests Running

- 1.4.5 Concurrent Requests Scheduled

- 1.5 No of Concurrent Requests in Blocked State

- 1.5.1 Concurrent Program Name

- 1.5.2 No of Concurrent Requests in Blocked State

- 1.6 No. of Include and Exclude Specialization Rules

- 1.6.1 Application Id

- 1.6.2 Concurrent Queue Name

- 1.6.3 Manager

- 1.6.4 Total Exclude Rules

- 1.6.5 Total Include Rules

- 1.7 Pending Requests (Normal)

- 1.7.1 Concurrent Program Name

- 1.7.2 Concurrent Program Short Name

- 1.7.3 Normal Pending Time

- 1.7.4 Phase

- 1.7.5 Request ID

- 1.7.6 Request Start Date

- 1.7.7 Status

- 1.7.8 Username

- 1.8 Pending Requests (Standby)

- 1.8.1 Concurrent Program Name

- 1.8.2 Concurrent Program Short Name

- 1.8.3 Phase

- 1.8.4 Request Id

- 1.8.5 Request Start Date

- 1.8.6 Standby Pending Time

- 1.8.7 Status

- 1.8.8 Username

- 1.9 Response

- 1.9.1 Status

- 1.10 Running Requests

- 1.10.1 Concurrent Program Name

- 1.10.2 Concurrent Program Short Name

- 1.10.3 Phase

- 1.10.4 Request ID

- 1.10.5 Request Start Date

- 1.10.6 Running Time

- 1.10.7 Status

- 1.10.8 Username

- 1.11 Tolerance Level For Long Running Request

- 1.11.1 Concurrent Manager

- 1.11.2 Concurrent Program Name

- 1.11.3 Concurrent Program Short Name

- 1.11.4 Phase

- 1.11.5 Request Id

- 1.11.6 Request Start Date

- 1.11.7 Running Time

- 1.11.8 Status

- 1.11.9 Tolerance on Average Execution Time(%)

- 1.11.10 Username

2 Custom Oracle Concurrent Program

- 2.1 Basic Information

- 2.1.1 Average Run Time

- 2.1.2 Maximum Run Time

- 2.1.3 Minimum Run Time

- 2.1.4 Requests Completed Successfully

- 2.1.5 Requests Completed with Errors

- 2.1.6 Requests Completed with Warnings

- 2.2 Concurrent Requests in Blocked State

- 2.2.1 Blocking Action

- 2.2.2 Blocking Id

- 2.2.3 Blocking Inst. Id

- 2.2.4 Blocking Minutes

- 2.2.5 Blocking Module

- 2.2.6 Concurrent Program Name

- 2.2.7 Concurrent Request Inst. Id

- 2.2.8 Concurrent Request SID

- 2.2.9 Request Id

- 2.3 Monitor Schedule for Requests

- 2.3.1 Concurrent Program Name

- 2.3.2 Concurrent Program Short Name

- 2.3.3 Request Id

- 2.3.4 Resubmit Interval Days

- 2.3.5 Resubmit Interval Hours

- 2.3.6 Resubmit Interval Minutes

- 2.3.7 Resubmit Interval Months

- 2.3.8 Resubmit Interval Unit Code

- 2.4 No. of Incomplete Requests by Status

- 2.4.1 Concurrent Requests Inactive (No Manager)

- 2.4.2 Concurrent Requests Inactive (On Hold)

- 2.4.3 Concurrent Requests Pending (Normal)

- 2.4.4 Concurrent Requests Pending (Standby)

- 2.4.5 Concurrent Requests Running

- 2.4.6 Concurrent Requests Scheduled

- 2.5 No. of Hourly Completed Requests by Status

- 2.5.1 Concurrent Requests Completed Successfully

- 2.5.2 Concurrent Requests Completed With Error

- 2.5.3 Concurrent Requests Completed With Warning

- 2.5.4 Concurrent Requests Error Rate (%)

- 2.5.5 Concurrent Requests Successful Requests Rate (%)

- 2.5.6 Concurrent Requests Warning Rate (%)

- 2.6 No. of Concurrent Requests in Blocked State

- 2.6.1 Concurrent Program Name

- 2.6.2 Total Blocked Requests

- 2.7 Pending Requests (Standby)

- 2.7.1 Concurrent Manager

- 2.7.2 Concurrent Program Name

- 2.7.3 Concurrent Program Short Name

- 2.7.4 Phase

- 2.7.5 Request Id

- 2.7.6 Request Start Date

- 2.7.7 Standby Pending Time

- 2.7.8 Status

- 2.7.9 Username

- 2.8 Pending Requests (Normal)

- 2.8.1 Concurrent Manager

- 2.8.2 Concurrent Program Name

- 2.8.3 Concurrent Program Short Name

- 2.8.4 Normal Pending Time

- 2.8.5 Phase

- 2.8.6 Request Id

- 2.8.7 Request Start Date

- 2.8.8 Status

- 2.8.9 Username

- 2.9 Requests Completed with Error

- 2.9.1 Concurrent Program Name

- 2.9.2 Concurrent Program Short Name

- 2.9.3 Execution Time

- 2.9.4 Phase

- 2.9.5 Request ID

- 2.9.6 Request Start Date

- 2.9.7 Status

- 2.9.8 Username

- 2.10 Requests Completed Successfully

- 2.10.1 Concurrent Program Name

- 2.10.2 Concurrent Program Short Name

- 2.10.3 Execution Time

- 2.10.4 Phase

- 2.10.5 Request End Date

- 2.10.6 Request Id

- 2.10.7 Request Start Date

- 2.10.8 Status

- 2.10.9 Username

- 2.11 Requests Completed with Warning

- 2.11.1 Concurrent Program Name

- 2.11.2 Concurrent Program Short Name

- 2.11.3 Execution Time

- 2.11.4 Phase

- 2.11.5 Request ID

- 2.11.6 Request Start Date

- 2.11.7 Status

- 2.11.8 Username

- 2.12 Response

- 2.12.1 Status

- 2.13 Running Requests

- 2.13.1 Concurrent Manager

- 2.13.2 Concurrent Program Name

- 2.13.3 Concurrent Program Short Name

- 2.13.4 Phase

- 2.13.5 Request Id

- 2.13.6 Request Start Date

- 2.13.7 Running Time

- 2.13.8 Status

- 2.13.9 Username

- 2.14 Tolerance Level For Long Running Request

- 2.14.1 Concurrent Manager

- 2.14.2 Concurrent Program Name

- 2.14.3 Concurrent Program Short Name

- 2.14.4 Phase

- 2.14.5 Request Id

- 2.14.6 Request Start Date

- 2.14.7 Running Time

- 2.14.8 Status

- 2.14.9 Tolerance on Average Execution Time(%)

- 2.14.10 Username

- 2.15 Unscheduled Requests

- 2.15.1 Concurrent Program Name

- 2.15.2 Concurrent Program Short Name

- 2.15.3 Repeating schedule Request

3 Forms Listener for EBS R12

- 3.1 Forms Middle-Tier Processes

- 3.1.1 CPU Utilization by Forms mid-tier Processes (%)

- 3.1.2 IP Address

- 3.1.3 Memory Utilization by Forms mid-tier Processes(%)

- 3.1.4 Process ID

- 3.1.5 User Name

- 3.2 Load

- 3.2.1 Number of Forms Processes

- 3.2.2 Total CPU Utilization (%)

- 3.2.3 Total Memory Utilization (%)

- 3.3 Response

- 3.3.1 Status

4 Forms Listener for Oracle Applications 11i

- 4.1 Forms Middle-Tier Processes

- 4.1.1 CPU Utilization by Forms mid-tier Processes (%)

- 4.1.2 IP Address

- 4.1.3 Memory Utilization by Forms mid-tier Processes(%)

- 4.1.4 Process ID

- 4.1.5 User Name

- 4.2 Load

- 4.2.1 Number of Forms Processes

- 4.2.2 Total CPU Utilization (%)

- 4.2.3 Total Memory Utilization (%)

- 4.3 Response

- 4.3.1 Status

5 HTTP Server for Oracle Applications 11i

- 5.1 Host Metrics

- 5.1.1 Name

- 5.2 Process Metrics

- 5.2.1 Host

- 5.2.2 Name

- 5.3 Response

- 5.3.1 Homepage Download, Milliseconds

- 5.3.2 Status

- 5.4 dms_cProcessInfo Metrics

- 5.4.1 Full Name

- 5.4.2 Host

- 5.4.3 Name

- 5.4.4 Process

- 5.4.5 cpuTime.value, msecs

- 5.4.6 heapSize.value, kilobytes

- 5.4.7 host.value

- 5.4.8 pid.value

- 5.4.9 totMem.value

- 5.4.10 upTime.value, msecs

- 5.5 ohs_module Metrics

- 5.5.1 Full Name

- 5.5.2 Host

- 5.5.3 Name

- 5.5.4 Process

- 5.5.5 decline.count, ops

- 5.5.6 handle.active, threads

- 5.5.7 handle.avg, usecs

- 5.5.8 handle.completed

- 5.5.9 handle.currentProcessingTime, seconds

- 5.5.10 handle.currentThroughput, requests/sec

- 5.5.11 handle.maxTime, usecs

- 5.5.12 handle.minTime, usecs

- 5.5.13 handle.time, usecs

- 5.5.14 ohs_server

- 5.6 ohs_server Metrics

- 5.6.1 Full Name

- 5.6.2 Host

- 5.6.3 Name

- 5.6.4 Process

- 5.6.5 childFinish.count, ops

- 5.6.6 childStart.count, ops

- 5.6.7 connection.active, threads

- 5.6.8 connection.avg, usecs

- 5.6.9 connection.completed

- 5.6.10 connection.currentTime, seconds

- 5.6.11 connection.maxTime, usecs

- 5.6.12 connection.minTime, usecs

- 5.6.13 connection.time, usecs

- 5.6.14 handle.active, threads

- 5.6.15 handle.avg, usecs

- 5.6.16 handle.completed

- 5.6.17 handle.maxTime, usecs

- 5.6.18 handle.minTime, usecs

- 5.6.19 handle.time, usecs

- 5.6.20 internalRedirect.count, ops

- 5.6.21 numMods.value

- 5.6.22 request.active, threads

- 5.6.23 request.avg, usecs

- 5.6.24 request.completed

- 5.6.25 request.currentProcessingTime, seconds

- 5.6.26 request.currentThroughput, requests/sec

- 5.6.27 request.maxTime, usecs

- 5.6.28 request.minTime, usecs

- 5.6.29 request.time, usecs

6 Oracle Applications JVM Usage

- 6.1 Application Modules Count

- 6.1.1 Application Module Pools

- 6.1.2 Total Application Modules

- 6.1.3 Total Locked Application Modules

- 6.2 Cached Objects

- 6.2.1 Total Cached Components

- 6.2.2 Total Objects

- 6.3 Locked/Leaked AOL/J Connections

- 6.3.1 Leaked AOL/J Connections

- 6.3.2 Locked AOL/J Connections

- 6.4 OC4J JVM Instance Metrics

- 6.4.1 OC4J JVM - Active Threads

- 6.4.2 OC4J JVM - CPU Usage (%)

- 6.4.3 OC4J JVM - Memory Usage (MB)

- 6.4.4 OC4J JVM Instance - Aborted Transactions

- 6.4.5 OC4J JVM Instance - Active EJB Methods

- 6.4.6 OC4J JVM Instance - Active Requests

- 6.4.7 OC4J JVM Instance - Active Sessions

- 6.4.8 OC4J JVM Instance - Active Transactions

- 6.4.9 OC4J JVM Instance - Committed Transactions

- 6.4.10 OC4J JVM Instance - EJB Method Execution Rate (per second)

- 6.4.11 OC4J JVM Instance - EJB Method Execution Time (seconds)

- 6.4.12 OC4J JVM Instance - Heap Usage (MB)

- 6.4.13 OC4J JVM Instance - Open JDBC Connections

- 6.4.14 OC4J JVM Instance - Request Processing Time (seconds)

- 6.4.15 OC4J JVM Instance - Requests Per Second

- 6.4.16 OC4J JVM Instance - Start Time (ms since Epoch)

- 6.4.17 OC4J JVM Instance - Total JDBC Connections

- 6.5 Response

- 6.5.1 Status

7 Oracle Concurrent Processing

- 7.1 Active Concurrent Requests by Application

- 7.1.1 Application Name

- 7.1.2 Application Short Name

- 7.1.3 Non-Repeating Pending requests (Normal and Standby)

- 7.1.4 Non-Repeating Running requests

- 7.1.5 Repeating Pending requests (Normal and Standby)

- 7.1.6 Repeating Running requests

- 7.2 Activity

- 7.2.1 Active Service Processes

- 7.2.2 Concurrent Requests Running

- 7.3 Capacity Utilization of Concurrent Managers

- 7.3.1 Manager Name

- 7.3.2 Utilized Capacity

- 7.4 Concurrent Requests in Blocked State

- 7.4.1 Blocking Action

- 7.4.2 Blocking ID

- 7.4.3 Blocking Inst. Id

- 7.4.4 Blocking Minutes

- 7.4.5 Blocking Module

- 7.4.6 Concurrent Program Name

- 7.4.7 Concurrent Request Inst. Id

- 7.4.8 Concurrent Request SID

- 7.4.9 Request ID

- 7.5 No. of Hourly Completed Requests by Status

- 7.5.1 Concurrent Requests Completed Successfully

- 7.5.2 Concurrent Requests Completed With Error

- 7.5.3 Concurrent Requests Completed With Warning

- 7.5.4 Concurrent Requests Error Rate (%)

- 7.5.5 Concurrent Requests Successful Requests Rate (%)

- 7.5.6 Concurrent Requests Warning Rate (%)

- 7.6 No of Incomplete Requests by Status

- 7.6.1 Concurrent Requests Inactive (No Manager)

- 7.6.2 Concurrent Requests Inactive (On Hold)

- 7.6.3 Concurrent Requests Pending (Normal)

- 7.6.4 Concurrent Requests Pending (Standby)

- 7.6.5 Concurrent Requests Running

- 7.6.6 Concurrent Requests Scheduled

- 7.7 Pending Requests (Standby)

- 7.7.1 Concurrent Program Name

- 7.7.2 Concurrent Program Short Name

- 7.7.3 Phase

- 7.7.4 Request Id

- 7.7.5 Request Start Date

- 7.7.6 Standby Pending Time

- 7.7.7 Status

- 7.8 Pending Requests (Normal)

- 7.8.1 Concurrent Program Name

- 7.8.2 Concurrent Program Short Name

- 7.8.3 Normal Pending Time

- 7.8.4 Phase

- 7.8.5 Request Id

- 7.8.6 Request Start Date

- 7.8.7 Status

- 7.8.8 Username

- 7.9 Running Requests

- 7.9.1 Concurrent Program Name

- 7.9.2 Concurrent Program Short Name

- 7.9.3 Phase

- 7.9.4 Request ID

- 7.9.5 Request Start Date

- 7.9.6 Running Time

- 7.9.7 Status

- 7.9.8 Username

- 7.10 No of Concurrent Requests in Blocked State

- 7.10.1 Concurrent Program Name

- 7.10.2 No of Concurrent Requests in Blocked State

- 7.11 Tolerance Level For Long Running Request

- 7.11.1 Concurrent Manager

- 7.11.2 Concurrent Program Name

- 7.11.3 Concurrent Program Short Name

- 7.11.4 Phase

- 7.11.5 Request ID

- 7.11.6 Request Start Date

- 7.11.7 Running Time

- 7.11.8 Status

- 7.11.9 Tolerance on Average Execution Time (%)

- 7.11.10 Username

- 7.12 Running Request Sets

- 7.12.1 Concurrent Request Set Name

- 7.12.2 Phase

- 7.12.3 Request Id

- 7.12.4 Requested Start Date

- 7.12.5 Running Time

- 7.12.6 Status

- 7.13 Failed Request Sets

- 7.13.1 Concurrent Request Set Name

- 7.13.2 Execution Time

- 7.13.3 Phase

- 7.13.4 Request ID

- 7.13.5 Requested Start Date

- 7.13.6 Status

- 7.13.7 User Name

- 7.14 Not Started Request Sets

- 7.14.1 Concurrent Queue Name

- 7.14.2 Concurrent Request Set Name

- 7.14.3 Request Id

- 7.14.4 Requested Start Date

- 7.14.5 Status

- 7.14.6 User Name

- 7.14.7 Wait Time

- 7.15 Unscheduled Request Sets

- 7.15.1 Concurrent Request Set Name

- 7.15.2 Request Id

- 7.15.3 Status

8 Oracle E-Business Suite

- 8.1 Abandoned Nodes

- 8.1.1 Node Name

- 8.1.2 Node Type

- 8.1.3 Status

- 8.2 Activity

- 8.2.1 Active Service Processes

- 8.2.2 Concurrent Requests Running

- 8.2.3 Forms Sessions

- 8.3 Applications System Status

- 8.3.1 Apps Metric Type

- 8.3.2 Host Name

- 8.3.3 Host Platform

- 8.3.4 Last Update Date

- 8.3.5 Metric Name

- 8.3.6 Service Description

- 8.3.7 Service Name

- 8.3.8 Service Status Code

- 8.3.9 Service Type

- 8.4 Applications by Errored Execs

- 8.4.1 Application Name

- 8.4.2 Application Short Name

- 8.4.3 Errored Executions

- 8.4.4 Errored Executions (%)

- 8.4.5 Node Name

- 8.4.6 Total Executions

- 8.5 Applications by Pending Requests

- 8.5.1 Application Name

- 8.5.2 Application Short Name

- 8.5.3 Number of Pending Requests

- 8.6 Concurrent Managers Configured

- 8.6.1 Number of Configured Concurrent Managers

- 8.7 Configuration Changes (Last 24 hours)

- 8.7.1 Context Files Edited

- 8.7.2 Invalid Database Objects

- 8.7.3 Last Update Date

- 8.7.4 Patches Applied

- 8.7.5 Site Level Profile Options Changed

- 8.8 Forms Database Sessions per Application

- 8.8.1 Application Name

- 8.8.2 Application Short Name

- 8.8.3 Number of Forms Database

- 8.9 Native Services

- 8.9.1 Application Name

- 8.9.2 Application Short Name

- 8.9.3 Service Actual Processes

- 8.9.4 Service Application Name

- 8.9.5 Service Handle

- 8.9.6 Service Message

- 8.9.7 Service Name

- 8.9.8 Service Status

- 8.9.9 Service Target Processes

- 8.10 Oracle Applications Internal System Alerts

- 8.10.1 Last Update Date

- 8.10.2 New Oracle Applications System Alert Occurrences

- 8.10.3 New Oracle Applications System Alerts

- 8.10.4 Open Oracle Applications System Alert Occurrences

- 8.10.5 New Oracle Applications System Alerts

- 8.11 Processes and Requests per Concurrent Manager

- 8.11.1 Available Processes

- 8.11.2 Concurrent Manager Name

- 8.11.3 Normal Pending Requests

- 8.11.4 Running Requests

- 8.11.5 Standby Pending Request

- 8.12 Programs by Average Running Time

- 8.12.1 Average Running Time

- 8.12.2 Concurrent Program Name

- 8.12.3 Maximum Running Time

- 8.12.4 Total Executions

- 8.12.5 User Concurrent Program Name

- 8.13 Programs by Errored Executions

- 8.13.1 Concurrent Program Name

- 8.13.2 Executions Errored (%)

- 8.13.3 Total Executions

- 8.13.4 Total Executions (Errored)

- 8.13.5 User Concurrent Program Name

- 8.14 Programs by Executions

- 8.14.1 Concurrent Program Name

- 8.14.2 Errored Executions (%)

- 8.14.3 Successful Executions (%)

- 8.14.4 Total Executions

- 8.14.5 User Concurrent Program Name

- 8.15 Programs by Total Running Time

- 8.15.1 Concurrent Program Name

- 8.15.2 Successful Executions (%)

- 8.15.3 Total Executions

- 8.15.4 Total Running Time

- 8.15.5 User Concurrent Program Name

- 8.16 Response

- 8.16.1 Status

- 8.17 Top Pending Requests

- 8.17.1 Manager Name

- 8.17.2 Pending Time

- 8.17.3 Phase

- 8.17.4 Program Name

- 8.17.5 Program Short Name

- 8.17.6 Request ID

- 8.17.7 Request Start Date

- 8.17.8 Status

- 8.17.9 User Name

- 8.18 Top Running Requests

- 8.18.1 Manager Name

- 8.18.2 Phase

- 8.18.3 Program Name

- 8.18.4 Program Short Name

- 8.18.5 Request ID

- 8.18.6 Request Start Date

- 8.18.7 Running Time

- 8.18.8 Status

- 8.18.9 User Name

- 8.19 Top Scheduled Requests

- 8.19.1 Manager Name

- 8.19.2 Phase

- 8.19.3 Program Name

- 8.19.4 Program Short Name

- 8.19.5 Request ID

- 8.19.6 Request Start Date

- 8.19.7 Scheduled to Run in (Minutes)

- 8.19.8 Status

- 8.19.9 User Name

- 8.20 Top Users (Requests Submitted)

- 8.20.1 Number of Requests

- 8.20.2 User Name

- 8.21 Users by Pending Requests

- 8.21.1 Number of Pending Requests

- 8.21.2 User Name

- 8.22 Users by Running Requests

- 8.22.1 Number of Running Requests

- 8.22.2 User Name

- 8.23 Web Users

- 8.23.1 Number of Web Users (Hourly)

- 8.24 Workflow Agent Activity

- 8.24.1 Errored Business Event System Messages

- 8.24.2 Expired Business Event System Messages

- 8.24.3 Processed Business Event System Messages

- 8.24.4 Ready Business Event System Messages

- 8.24.5 Undeliverable Business Event System Messages

- 8.24.6 Waiting Business Event System Messages

- 8.25 Workflow Notifications

- 8.25.1 Errored Workflow Notifications

- 8.25.2 Unsent Workflow Notifications

9 Oracle E-Business Suite Conflict Resolution Manager

- 9.1 CRM Inactive Minutes

- 9.1.1 Concurrent Queue Name

- 9.1.2 Last Work End Date

- 9.1.3 No. of minutes elapsed since last work end

- 9.2 CRM in Blocked State in a Work Cycle

- 9.2.1 Blocking Minutes

- 9.2.2 Blocking Process ID

- 9.2.3 Blocking Process Name

- 9.2.4 Conflict Resolution Manager SID

- 9.2.5 No. of minutes elapsed of running cycle

- 9.3 Response

- 9.3.1 Status

10 Oracle E-Business Suite Node

- 10.1 Configuration File Discrepancies

- 10.1.1 Discrepancy Files

- 10.1.2 Discrepancy Count

- 10.2 Cutover Status

- 10.2.1 Cutover Status Running

- 10.2.2 Cutover Status Failed

- 10.2.3 Cutover Status Completed

- 10.3 Response

- 10.3.1 Status

11 Oracle E-Business Suite Output Post Processor

- 11.1 Output Post processor Hang Error

- 11.1.1 Error Message

- 11.1.2 Request ID

- 11.1.3 Request having hang error

- 11.2 No. of NoResponse and Timeout Error Requests

- 11.2.1 No. of NoResponse Error Requests

- 11.2.2 Output Post processor Hang Error

- 11.2.3 Error Message

- 11.2.4 Request ID

- 11.2.5 Request having hang error

- 11.2.6 No. of Timeout Error Requests

- 11.3 No Response Error Requests

- 11.3.1 Error Message

- 11.3.2 Request ID

- 11.4 Response

- 11.4.1 Status

- 11.5 Timeout Error Requests

- 11.5.1 Error Message

- 11.5.2 Request ID

12 Oracle MobileApps Telnet Listener

- 12.1 MobileApps Dispatcher Port Listening Status

- 12.1.1 Listening Status

- 12.1.2 Port

- 12.1.3 Process Name

- 12.1.4 Process Status

- 12.2 MobileApps Telnet Ports Listening Status

- 12.2.1 Listening status

- 12.2.2 Port

- 12.3 Response

- 12.3.1 Status

13 Oracle Workflow Agent Listener

- 13.1 Errored Java Events

- 13.1.1 Errored Java Events

- 13.2 Errored PLSQL Events

- 13.2.1 Errored PLSQL Event

- 13.3 Pending Java Events

- 13.3.1 Pending Java Events

- 13.4 Pending PLSQL Events

- 13.4.1 Pending PLSQL Events

- 13.5 Response

- 13.5.1 Status

14 Oracle Workflow Background Engine

- 14.1 Deferred Items

- 14.1.1 Deferred Items

- 14.2 Response

- 14.2.1 Status

15 Oracle Workflow Notification Mailer

- 15.1 Pending Inbound Notification Events

- 15.1.1 Pending Inbound Notification Events

- 15.2 Pending Outbound Notification Events

- 15.2.1 Pending Outbound Notification Events

- 15.3 Pending Outbound Notifications

- 15.3.1 Pending Outbound Notifications

- 15.4 Response

- 15.4.1 Status

16 Reports Server for Oracle Applications 11i

- 16.1 Load

- 16.1.1 Total CPU (%)

- 16.1.2 Total Memory (%)

- 16.1.3 Total number of users

- 16.2 Response

- 16.2.1 Status

- 16.3 Sessions

- 16.3.1 Process Id

- 16.3.2 Session CPU (%)

- 16.3.3 Session Memory (%)

A Retired Metrics

- A.1 Retired Metrics

Preface

This manual is a compilation of the metrics provided in Enterprise Manager Application Management Pack for Oracle E-Business Suite. Application Management Pack is a component of Application Management Suite or E-Business Suite Plug-in. This document is intended to describe metrics only for Application Management Pack for Oracle E-Business Suite and not for Real User Experience Insight (RUEI).

Audience

This document is intended for users managing or monitoring Oracle E-Business Suite using Applications Management Pack for Oracle E-Business suite.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Related Documents

For more information, see the following documents in the Oracle E-Business Suite and Oracle Enterprise Manager 12c documentation sets:

- Oracle Application Management Pack for Oracle E-Business Suite Guide

- Getting Started with Oracle Application Management Pack for Oracle E-Business Suite (AMP) (Doc ID 1623105.1)
This book is available from My Oracle Support:

https://support.oracle.com/epmos/faces/DocumentDisplay?id=1623105.1

- Oracle Enterprise Manager Concepts

- Oracle Enterprise Manager Administrator's Guide

Conventions

The following text conventions are used in this document:

Convention

Meaning

boldface

Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.

italic

Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.

monospace

Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.

What's Changed in this Guide?

The revisions listed below identify information updates, structural changes, as well as relocation of information to other guides.

Since the last revision, the following changes have been made:

- Added: Oracle E-Business Suite Conflict Resolution Manager metrics, Oracle E-Business Suite Output Post Processor metrics, Oracle HTTP Server metrics, Oracle Concurrent Processing metrics, Custom Oracle Concurrent Manager metrics, Custom Oracle Concurremt Program metrics, Oracle E-Business Suite Node metrics, Oracle MobileApps Telnet Listener metrics.

- Modified: Oracle Concurrent Manager renamed to Oracle Concurrent Processing, Oracle E-Business Suite metrics (Application by Errored Execs has a new Node name metric).

- Removed: For list of metrics retired in this release, see Appendix A, "Retired Metrics".

How to Use This Manual

The Oracle Application Management Pack for Oracle E-Business Suite Metric Reference Manual lists all the relevant target metrics that Enterprise Manager monitors.

This preface describes:

- Structure of This Manual

- Background Information on Metrics, Thresholds, and Alerts

- Troubleshooting Metrics

Structure of This Manual

This manual contains a chapter for each Oracle E-Business Suite target for which there are metrics.

The metrics in each chapter are in alphabetical order according to category.

Metric Information

The information for each metric comprises a description, summary of the metric's "vital statistics", data source (if available), and user action. The following list provides greater detail:

- Description
Explanation following the metric name. This text defines the metric and, when available, provides additional information pertinent to the metric.

- Metric Summary
Explains in table format the target version, collection frequency, default warning threshold, and default critical threshold for the metric.

- Data Source
How the metric is calculated. In some metrics, data source information is not available.

- User Action
Suggestions of how to solve the problem causing the alert. In some metrics, user actions are not available or applicable. Users can define automated corrective actions to respond to the metric threshold alerts. For information about creating corrective actions, see the "Creating Corrective Actions" section of the Oracle Enterprise Manager Cloud Control Administrator's Guide.

Examples of Metric Summary Tables

This section provides examples of Metric Summary tables you will see in the Oracle Application Management Pack for Oracle E-Business Suite Metric Reference Manual.

When default thresholds are not defined for a metric, only the target version and collection frequency are available.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

Definitions of Columns in Metric Summary Tables

As previously mentioned, the Metric Summary table is part of the overall metric information. The following table provides descriptions of columns in the Metric Summary table.

Column Header

Column Definition

Target Version

Version of the target. For example, E-Business Suite 11i, R12, R12.1, and R12.2.

Collection Frequency

The rate at which the Management Agent collects data. The collection frequency for a metric comes from the Enterprise Manager default collection file for that target type.

Default Warning Threshold

Value that indicates whether a warning alert should be initiated. If the evaluation of the warning threshold value returns a result of TRUE for the specified number of consecutive occurrences defined for the metric, an alert triggers at the warning severity level.

Default Critical Threshold

Value that indicates whether a critical alert should be initiated. If the evaluation of the critical threshold value returns a result of TRUE for the specified number of consecutive occurrences defined for the metric, an alert triggers at the critical severity level.

Abbreviations and Acronyms

To reduce the page count in this document, the following abbreviations and acronyms are used:

Abbreviation/Acronym

Name

Management Agent or Agent

Oracle Management Agent

Database

Oracle Database

Management Service or OMS

Oracle Management Service

Management Repository or Repository

Oracle Management Repository

Background Information on Metrics, Thresholds, and Alerts

An event is a significant occurrence on a managed target that typically indicates something has occurred outside normal operating conditions, such as a performance threshold violation, an unapproved change in application configuration files, or job failure. An event can also be raised to signal successful operations or a job successfully completed.

Existing Enterprise Manager customers may be familiar with metric alerts and metric collection errors. For Enterprise Manager 12c, metric alerts are a type of event. A metric alert event is generated when an alert occurs for a metric on a specific target (Example: CPU utilization for a host target) or a metric on a target and object combination (Example: Space usage on a specific tablespace of a database target.)

Thresholds are boundary values against which monitored metric values are compared. For example, you can define warning and critical thresholds to monitor the number of pending concurrent requests. If a large number of concurrent requests are pending and an incident is raised and then you can receive an notification. This example helps in the proactive monitoring of concurrent requests. Some thresholds are predefined by Oracle, and others are not.

Once a threshold is reached, a metric alert is generated. This alert is an indicator signifying that a particular condition has been encountered and is triggered when one of the following conditions is true:

- A threshold is reached.

- An alert has been cleared.

- The availability of a monitored service changes. For example, the availability of an application server changes from up to down.

- A specific condition occurs. For example, an alert is triggered whenever an error message is written to a database alert log file.

Alerts are detected through a polling-based mechanism by checking for the monitored condition from a separate process at regular, predefined intervals.

See Also:
See the Oracle Enterprise Manager Concepts manual and the Oracle Enterprise Manager Administrator's Guide for additional information about metrics, thresholds, and alerts.

Editing

Out of the box, Enterprise Manager comes with thresholds for critical metrics. Warning and critical thresholds are used to generate an alert, letting you know of impending problems so that you can address them in a timely manner.

To better suit the monitoring needs of your organization, you can edit the thresholds provided by Enterprise Manager and define new thresholds. When defining thresholds, the key is to choose acceptable values to avoid unnecessary alerts, while still being notified of issues in a timely manner.

You can establish thresholds that will provide pertinent information in a timely manner by defining metric baselines that reflect how your system runs for a normal period of time.

The metrics listed on the Edit Thresholds page are either default metrics provided by Oracle or metrics whose thresholds you can change.

Accessing Metrics Using the Cloud Control Console

To access metrics in the Cloud Control Console, use the All Metrics page associated with the Oracle E-Business Suite targets by doing the following:

1. From the Cloud Control Console, choose the Oracle E-Business Suite target.

2. On the target's home page, click All Metrics in the Related Links section.

3. On the All Metrics page, choose the metric of interest.

Troubleshooting Metrics

In the unlikely situation that a metric does not report a correct value, you need to determine if the problem is related to the:

- Metric providing the wrong values or failing with an error, or

- If the problem is after the Management Agent in the execution flow of the metric, that is, the metric value is correct but, for some reason, the data is not reaching the Oracle Management Service.

To aid you in this determination, Oracle provides the Metric Browser; a troubleshooting tool that can be used with Enterprise Manager to see the raw data being collected by the Management Agent.

Accessing the Metric Browser

When enabled, the Metric Browser can be accessed using a web browser such as Mozilla Firefox or Microsoft Internet Explorer, using a URL of the form:

http|https://agent_hostname:agent_port/emd/browser/main

for example

http://myServer.myDomain:3872/emd/browser/main

Note:
You can determine the protocol (http or https), the host name, and the Management Agent port that should be used from the output of the following command (run on the Management Agent host):
agent_home/bin/emctl status agent

The Management Agent URL, listed in the output to that command, needs only to have browser placed between emd and main.

By default, the Metric Browser is disabled. When the Metric Browser is disabled, you receive the following error:

HTTP Error 403 - Forbidden if the metric browser has not been enabled.

How to Enable the Metric Browser and the Management Agent Browser for the Oracle Management Agent

To enable the Metric Browser:

1. Set the enableMetricBrowser property in the Management Agent's emd.properties file. The location of that file depends on the type of Management Agent you are working with:

- For the Cloud Control (central|standalone) Management Agent, the file is:
AGENT_HOME/sysman/config/emd.properties

- For a clustered (RAC) Management Agent install, the file is:
AGENT_HOME/hostname/sysman/config/emd.properties

- For the Database Control Management Agent, the file is:
DATABASE_HOME/hostname_SID/sysman/config/emd.properties

- For Application Server Control Management Agent, the file is:
AS_HOME/sysman/config/emd.properties

2. Make a backup copy of the emd.properties file.

3. Edit the file and locate the line that reads:

#To enable the metric browser, uncomment the following line
#This is a reloadable parameter
#
#enableMetricBrowser=true

4. Uncomment the line: #enableMetricBrowser=true, so that it reads:
enableMetricBrowser=true

5. Reload the Management Agent Configuration using the command:
AGENT_HOME/bin/emctl reload agent

6. After reloading the Management Agent, the Metric Browser will be enabled and therefore accessible using a browser.

Running the Metric Collection Outside the Management Agent

Running the metric collection outside the Management Agent is specific to each metric and requires a firsthand knowledge of each specific metric. Each metric has its own method of collecting its data and some metrics cannot be run standalone because they are calculated from other metrics.

An example of running the metric collection outside the Management Agent is the command line.

1 Custom Oracle Concurrent Manager

A concurrent manager is a process manager that coordinates the processes generated by users' requests to run various data-intensive programs. An Oracle E-Business Suite product group can have several concurrent managers. This chapter provides information about the metrics defined for the Custom Oracle Concurrent Manager. These metrics are also applicable to Oracle-delivered Concurrent Managers.

For more information about concurrent managers, see your Oracle E-Business Suite user documentation.

- Active Processes

- Capacity Utilization of Concurrent Managers

- Concurrent Requests in Blocked State

- Concurrent Requests by Status

- No of Concurrent Requests in Blocked State

- No. of Include and Exclude Specialization Rules

- Pending Requests (Normal)

- Pending Requests (Standby)

- Response

- Running Requests

- Tolerance Level For Long Running Request

1.1 Active Processes

This metric category provides information about the operating system (OS) processes associated with this concurrent manager on a node.

1.1.1 OS Process ID

This metric displays the OS Process Id associated with the concurrent request.

Target Version

Collection Frequency

All Versions

Every 1 Day

1.1.2 Process Status

This metric displays the status of the process.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

0

Not Defined

%value% Active Processes

1.1.3 Session Id

This metric displays the session ID of the process.

Target Version

Collection Frequency

All Versions

Every 1 Day

1.1.4 Target Node

This metric displays the node where the concurrent program is running.

Target Version

Collection Frequency

All Versions

Every 1 Day

1.2 Capacity Utilization of Concurrent Managers

This metric category provides information about the capacity utilization of this concurrent manager.

1.2.1 Manager Name

This metric displays the name of the concurrent manager.

Target Version

Collection Frequency

All Versions

Every 1 Day

1.2.2 Utilized Capacity

This metric compares the number of instances of concurrent managers running to the maximum number allowed instances and computes the capacity as a percentage of maximum allowed. This is calculated for a specific concurrent manager type. You can set an alert if the capacity utilization of concurrent managers drops below a specific threshold.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Day

Not Defined

Not Defined

Utilized Capacity of manager %manager_name%: %value%%" MESSAGE_NLSID="ebiz_capacity_utilization

Data Source

The number of instances per manager and the maximum number of allowed instances per manager is obtained from FND_CONCURRENT_QUEUES and the percentage is calculated.

1.3 Concurrent Requests in Blocked State

This metric category provides information about concurrent requests in a blocked state for this concurrent manager.

1.3.1 Blocking Action

This metric displays the blocking action for the requests in a blocked state for this concurrent manager.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.3.2 Blocking Id

This metric displays the blocking ID associated with the request in a blocked state.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.3.3 Blocking Inst. ID

This metric displays the instance ID of the blocking concurrent program as available from the GV$LOCK view.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.3.4 Blocking Minutes

This metric displays the number of minutes that the request is in a blocked state.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Hour

Not Defined

Not Defined

Concurrent Request %request_id% Blocked for %value% Minutes

1.3.5 Blocking Module

This metric displays the module to which the blocking concurrent program belongs.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.3.6 Concurrent Program Name

This metric displays the name of the concurrent program.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.3.7 Concurrent Request Inst. Id

This metric displays the ID associated with the concurrent request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.3.8 Concurrent Request SID

This metric displays the database SID associated with this concurrent request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.3.9 Request Id

This metric collects information on requests in a blocked state (such as row locks) for a specific concurrent manager.

You can set an alert to inform you if a request is in blocked state for more than a specific threshold.

Target Version

Collection Frequency

All Versions

Every 1 Hour

Data Source

Blocked requests are identified by joining FND_CONCURRENT_REQUESTS with gv$LOCK and gv$SESSION when the phase code of the request is 'R' for this concurrent manager.

User Action

Analyze the cause of the block and ensure that the issue is not widespread.

1.4 Concurrent Requests by Status

This metric category is used to collect information about concurrent requests by status for custom concurrent manager.

1.4.1 Concurrent Requests Inactive (On Hold)

This metric displays the number of inactive concurrent requests with a status of On Hold.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

%value% Requests are On Hold

1.4.2 Concurrent Requests Pending (Normal)

This metric displays the number of pending concurrent requests with a status of Normal.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

%value% Requests are Pending Normal

1.4.3 Concurrent Requests Pending (Standby)

This metric displays the number of pending concurrent requests with a status of Standby.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

%value% Requests are Pending Standby

1.4.4 Concurrent Requests Running

This metric displays the number of running concurrent requests.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

1.4.5 Concurrent Requests Scheduled

This metric displays the number of scheduled concurrent requests.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

%value% Requests are Scheduled

1.5 No of Concurrent Requests in Blocked State

This metric category provides the number of requests being processed by this manager, that are in a blocked state due to database locks.

1.5.1 Concurrent Program Name

This metric displays the name of the concurrent program.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

1.5.2 No of Concurrent Requests in Blocked State

This metric displays the number of requests that are in a blocked state because of database locks.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

%value% Concurrent Request are in Blocked State

1.6 No. of Include and Exclude Specialization Rules

This metric category provides information about the number of specialization rules for a concurrent manager. You can set thresholds to generate alerts if the number of rules exceeds a specific limit.

1.6.1 Application Id

This metric displays the application ID associated with the current application.

Target Version

Collection Frequency

All Versions

Every 1 Day

1.6.2 Concurrent Queue Name

This metric displays the name of the concurrent queue.

Target Version

Collection Frequency

All Versions

Every 1 Day

1.6.3 Manager

This metric displays the manager that is defined to read the request.

Target Version

Collection Frequency

All Versions

Every 1 Day

1.6.4 Total Exclude Rules

This metric displays the total number of Exclude specialization rules.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Day

Not Defined

Not Defined

%value% Exclude Specialization Rules

1.6.5 Total Include Rules

This metric displays the total number of Include specialization rules.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Day

Not Defined

Not Defined

%value% Include Specialization Rules

1.7 Pending Requests (Normal)

This metric category provides information about the requests with this Concurrent Manager that are in a Pending phase, with a status of Normal

1.7.1 Concurrent Program Name

This metric displays the name of the concurrent program associated with the pending request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.7.2 Concurrent Program Short Name

This metric displays the name of the concurrent program associated with the pending request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.7.3 Normal Pending Time

This metric displays the length of time that the request is pending.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Hour

Not Defined

Not Defined

Request %request_id% Pending in Normal Status for %value% Minutes

1.7.4 Phase

This metric displays the request phase of the pending request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.7.5 Request ID

This metric displays the ID associated with the pending request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.7.6 Request Start Date

This metric displays the start date of the pending request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.7.7 Status

This metric displays the status of the pending request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.7.8 Username

This metric displays the user name associated with the pending request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.8 Pending Requests (Standby)

This metric category provides information about the requests with this Concurrent Manager, that are in Pending phase with a status of Standby.

1.8.1 Concurrent Program Name

This metric displays the name of the concurrent program associated with the pending request with a status of Standby.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.8.2 Concurrent Program Short Name

This metric displays the short name of the concurrent program associated with the pending request with a status of Standby.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.8.3 Phase

This metric displays the request phase of the pending request with a status of Standby.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.8.4 Request Id

This metric displays the ID associated with the pending request with a status of Standby.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.8.5 Request Start Date

This metric displays the start date of the pending request with a status of Standby.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.8.6 Standby Pending Time

This metric displays the length of time that the request is pending, with a status of Standby.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Hour

Not Defined

Not Defined

Request %request_id% Pending in Standby Status for %value% Minutes

1.8.7 Status

This metric displays the status of the pending request with a status of Standby.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.8.8 Username

This metric displays the user name associated with the pending request with a status of Standby.

Target Version

Collection Frequency

All Versions

Every 1 Hour

1.9 Response

This metric category provides information about the status of the Custom Oracle Concurrent Manager target.

1.9.1 Status

This metric specifies whether the Concurrent Manager is up and running.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

0

Database is down

User Action

Check if the Concurrent Manager is up.

1.10 Running Requests

This metric category provides information about the requests that are being run by this concurrent manager.

1.10.1 Concurrent Program Name

This metric displays the name of the concurrent program associated with the running request.

Target Version

Collection Frequency

All Versions

Every 1 Day

1.10.2 Concurrent Program Short Name

This metric displays the short name of the concurrent program associated with the running request.

Target Version

Collection Frequency

All Versions

Every 1 Day

1.10.3 Phase

This metric displays the phase of the running request.

Target Version

Collection Frequency

All Versions

Every 1 Day

1.10.4 Request ID

This metric displays the ID associated with the running request.

Target Version

Collection Frequency

All Versions

Every 1 Day

1.10.5 Request Start Date

This metric displays the start date of the running request.

Target Version

Collection Frequency

All Versions

Every 1 Day

1.10.6 Running Time

This metric displays the length of time that the concurrent request is running.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

Request %request_id% Running for %value% Minutes

1.10.7 Status

This metric displays the status of the running request.

Target Version

Collection Frequency

All Versions

Every 1 Day

1.10.8 Username

This metric displays the user name associated with the running request.

Target Version

Collection Frequency

All Versions

Every 1 Day

1.11 Tolerance Level For Long Running Request

This metric category provides information about tolerance levels for long-running requests. Tolerance level is calculated as a percentage of the running time to that of the average running time of all requests processed by this manager. This allows you to set an alert if the running time of a request exceeds a certain percentage of the average run time.

1.11.1 Concurrent Manager

This metric displays the name of the concurrent manager associated with the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

1.11.2 Concurrent Program Name

This metric displays the name of the concurrent program associated with the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

1.11.3 Concurrent Program Short Name

This metric displays the short name of the concurrent program associated with the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

1.11.4 Phase

This metric displays the request phase of the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

1.11.5 Request Id

This metric displays the ID associated with the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

1.11.6 Request Start Date

This metric displays the start date of the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

1.11.7 Running Time

This metric displays the length of time that the request is running.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

1.11.8 Status

This metric displays the status of the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

1.11.9 Tolerance on Average Execution Time(%)

This metric displays the percentage of the running time to that of the average running time.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

Request %request_id% is Running %value%% Longer Than The Average Execution Time

1.11.10 Username

This metric displays the user name associated with the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2 Custom Oracle Concurrent Program

This chapter provides information about the metrics defined for the Custom Oracle Concurrent Program target. These metrics are also applicable for Oracle-delivered concurrent programs.

For information about concurrent programs, see your Oracle E-Business Suite user documentation.

- Basic Information

- Concurrent Requests in Blocked State

- Monitor Schedule for Requests

- No. of Incomplete Requests by Status

- No. of Hourly Completed Requests by Status

- No. of Concurrent Requests in Blocked State

- Pending Requests (Standby)

- Pending Requests (Normal)

- Requests Completed with Error

- Requests Completed Successfully

- Requests Completed with Warning

- Response

- Running Requests

- Tolerance Level For Long Running Request

- Unscheduled Requests

2.1 Basic Information

This metric category provides basic information about specific concurrent programs.

2.1.1 Average Run Time

This metric displays the average run time for a task.

Target Version

Collection Frequency

All Versions

Every 1 Day

2.1.2 Maximum Run Time

This metric displays the maximum run time for a task.

Target Version

Collection Frequency

All Versions

Every 1 Day

2.1.3 Minimum Run Time

This metric displays the minimum run time for a task.

Target Version

Collection Frequency

All Versions

Every 1 Day

2.1.4 Requests Completed Successfully

This metric displays the number of successful requests completed to run tasks.

Target Version

Collection Frequency

All Versions

Every 1 Day

2.1.5 Requests Completed with Errors

This metric displays the number of requests with errors completed to run tasks.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

%value% Requests Completed with Errors"

2.1.6 Requests Completed with Warnings

This metric displays the number of requests completed with warnings to run tasks.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Day

Not Defined

Not Defined

%value% Requests Completed with Warnings

2.2 Concurrent Requests in Blocked State

This metric category provides information about the requests of this program that are in a blocked state due to database locks.

2.2.1 Blocking Action

This metric displays the blocking action for the requests in a blocked state for this concurrent program.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.2.2 Blocking Id

This metric displays the blocking ID associated with the request in a blocked state.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.2.3 Blocking Inst. Id

This metric displays the instance ID of the blocking concurrent program as available from the GV$LOCK view.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.2.4 Blocking Minutes

This metric displays the number of minutes that the request is in a blocked state.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

Concurrent Request %request_id% Blocked for %value% Minutes

2.2.5 Blocking Module

This metric displays the module to which the blocking concurrent program belongs.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.2.6 Concurrent Program Name

This metric displays the name of the concurrent program

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.2.7 Concurrent Request Inst. Id

This metric displays the ID associated with the concurrent request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.2.8 Concurrent Request SID

This metric displays the database SID associated with this concurrent request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.2.9 Request Id

This metric collects information on requests in a blocked state (such as row locks) for a specific concurrent manager.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.3 Monitor Schedule for Requests

This metric category collects the monitoring schedule of a specific concurrent program. You can set an alert if the concurrent program is not scheduled as per the recommend duration.

Data Source

The schedule for a concurrent program is available from the FND_CONCURRENT_REQUESTS table.

2.3.1 Concurrent Program Name

This metric displays the name of this concurrent program.

Target Version

Collection Frequency

All Versions

Every Day

2.3.2 Concurrent Program Short Name

This metric displays the short name of this concurrent program.

Target Version

Collection Frequency

All Versions

Every Day

2.3.3 Request Id

This metric displays the request ID.

Target Version

Collection Frequency

All Versions

Every Day

2.3.4 Resubmit Interval Days

This metric displays the interval in days between resubmissions.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every Day

Not Defined

Not Defined

Scheduled time for the request %request_id% should be less than equal to %critical_threshold% Days

2.3.5 Resubmit Interval Hours

This metric displays the interval in hours between resubmissions.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every Day

Not Defined

Not Defined

Scheduled time for the request %request_id% should be less than equal to %critical_threshold% Hours

2.3.6 Resubmit Interval Minutes

This metric displays the interval in minutes between resubmissions.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every Day

Not Defined

Not Defined

Scheduled time for the request %request_id% should be less than equal to %critical_threshold% Minutes

2.3.7 Resubmit Interval Months

This metric displays the interval in months between resubmissions.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every Day

Not Defined

Not Defined

Scheduled time for the request %request_id% should be less than equal to %critical_threshold% Months

2.3.8 Resubmit Interval Unit Code

This metric displays the unit code of the resubmission interval.

Target Version

Collection Frequency

All Versions

Every Day

2.4 No. of Incomplete Requests by Status

This metric category provides information about the number of requests of this program, which are in various stages of progress grouped by status.

2.4.1 Concurrent Requests Inactive (No Manager)

This metric displays the number of incomplete inactive concurrent requests with a status of No Manager.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

%value% Concurrent Requests are Inactive (No Manager)

2.4.2 Concurrent Requests Inactive (On Hold)

This metric displays the number of incomplete inactive concurrent requests with a status of On Hold.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

%value% Concurrent Requests are on hold

2.4.3 Concurrent Requests Pending (Normal)

This metric displays the number of incomplete pending concurrent requests with a status of Normal

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

%value% Concurrent Requests are Pending (Normal)

2.4.4 Concurrent Requests Pending (Standby)

This metric displays the number of incomplete pending concurrent requests with a status of Standby.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

%value% Concurrent Requests are Pending (Standby)

2.4.5 Concurrent Requests Running

This metric displays the number of running concurrent requests.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

2.4.6 Concurrent Requests Scheduled

This metric displays the number of scheduled concurrent requests.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

2.5 No. of Hourly Completed Requests by Status

This metric category provides information about the number of requests of this program completed in the last one hour grouped by status.

2.5.1 Concurrent Requests Completed Successfully

This metric displays the number of concurrent requests completed successfully.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.5.2 Concurrent Requests Completed With Error

This metric displays the number of concurrent requests completed with errors.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

%value% concurrent requests completed with error

2.5.3 Concurrent Requests Completed With Warning

This metric displays the number of concurrent requests completed with warnings.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

%value% concurrent requests completed with warning

2.5.4 Concurrent Requests Error Rate (%)

This metric displays the percentage of completed concurrent requests with errors.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

Concurrent Requests completion with error rate is %value%%%

2.5.5 Concurrent Requests Successful Requests Rate (%)

This metric displays the percentage of successfully completed concurrent requests.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

%value% Concurrent Requests are Pending (Standby)

2.5.6 Concurrent Requests Warning Rate (%)

This metric displays the percentage of completed concurrent requests with warnings.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

Concurrent Requests completion with warning rate is %value%%%

2.6 No. of Concurrent Requests in Blocked State

This metric category provides information about the number of requests of this program which are in a blocked state due to database locks.

2.6.1 Concurrent Program Name

This metric displays the name of the concurrent program.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.6.2 Total Blocked Requests

This metric displays the total number of concurrent requests that are in a blocked state due to database locks.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

%value% Requests in Blocked State

2.7 Pending Requests (Standby)

This metric category provides information about requests of this program that are in Pending phase with a status of Standby.

2.7.1 Concurrent Manager

This metric displays the name of the concurrent manager associated with the pending request with a status of Standby.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.7.2 Concurrent Program Name

This metric displays the name of the concurrent program associated with the pending request with a status of Standby.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.7.3 Concurrent Program Short Name

This metric displays the short name of the concurrent program associated with the pending request with a status of Standby.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.7.4 Phase

This metric displays the request phase of the pending request with a status of Standby.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.7.5 Request Id

This metric displays the ID associated with the pending request with a status of Standby.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.7.6 Request Start Date

This metric displays the start date of the pending request with a status of Standby.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.7.7 Standby Pending Time

This metric displays the length of time that the request is pending, with a status of Standby.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

Request %request_id% Pending in Standby Status for %value% Minutes

2.7.8 Status

This metric displays the status of the pending request with a status of Standby.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.7.9 Username

This metric displays the user name associated with the pending request with a status of Standby.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.8 Pending Requests (Normal)

This metric category provides information about the requests of this program that are in a pending phase with status of Normal.

2.8.1 Concurrent Manager

This metric displays the name of the concurrent manager associated with the pending request with a status of Normal.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.8.2 Concurrent Program Name

This metric displays the name of the concurrent program associated with the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.8.3 Concurrent Program Short Name

This metric displays the name of the concurrent program associated with the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.8.4 Normal Pending Time

This metric displays the length of time that the request is pending.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

Request %request_id% Pending in Normal Status for %value% Minutes

2.8.5 Phase

This metric displays the request phase of the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.8.6 Request Id

This metric displays the ID associated with the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.8.7 Request Start Date

This metric displays the start date of the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.8.8 Status

This metric displays the status of the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.8.9 Username

This metric displays the user name associated with the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.9 Requests Completed with Error

This metric category provides information about the concurrent requests that completed with errors.

2.9.1 Concurrent Program Name

This metric displays the name of the concurrent program associated with the completed request.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Hour

Not Defined

Not Defined

Request %request_id% Completed with Error for program %value%

2.9.2 Concurrent Program Short Name

This metric displays the short name of the concurrent program associated with the completed request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

2.9.3 Execution Time

This metric displays the length of time it took to complete the concurrent request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

2.9.4 Phase

This metric displays the phase of the completed request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

2.9.5 Request ID

This metric displays the ID associated with the completed request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

2.9.6 Request Start Date

This metric displays the start date of the completed request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

2.9.7 Status

This metric displays the status of the completed request.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Hour

Not Defined

Not Defined

Request %request_id% Completed with Error for program %program_name%

2.9.8 Username

This metric displays the user name associated with the completed request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

2.10 Requests Completed Successfully

This metric category provides information about the requests completed successfully in the last five minutes. This metric category is disabled by default to avoid performance issues.

2.10.1 Concurrent Program Name

This metric displays the name of the concurrent program associated with the request.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

2.10.2 Concurrent Program Short Name

This metric displays the name of the concurrent program associated with the request.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

2.10.3 Execution Time

This metric displays the length of time it took to complete the request.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

2.10.4 Phase

This metric displays the phase of the request.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

2.10.5 Request End Date

This metric displays the end date of the request.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

2.10.6 Request Id

This metric displays the ID associated with the request.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

2.10.7 Request Start Date

This metric displays the start date of the request.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

2.10.8 Status

This metric displays the status of the request.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

2.10.9 Username

This metric displays the user name associated with the request

Target Version

Collection Frequency

All Versions

Every 5 Minutes

2.11 Requests Completed with Warning

This metric category provides information about the concurrent requests that completed with warnings.

2.11.1 Concurrent Program Name

This metric displays the name of the concurrent program associated with the completed request.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Hour

Not Defined

Not Defined

Request %request_id% Completed with Warning for program %value%

2.11.2 Concurrent Program Short Name

This metric displays the short name of the concurrent program associated with the completed request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

2.11.3 Execution Time

This metric displays the length of time it took to complete the concurrent request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

2.11.4 Phase

This metric displays the phase of the completed request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

2.11.5 Request ID

This metric displays the ID associated with the completed request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

2.11.6 Request Start Date

This metric displays the start date of the completed request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

2.11.7 Status

This metric displays the status of the completed request.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Hour

Not Defined

Not Defined

Request %request_id% Completed with Warning for program %program_name%

2.11.8 Username

This metric displays the user name associated with the completed request.

Target Version

Collection Frequency

All Versions

Every 1 Hour

2.12 Response

This metric category provides information about the status of the Custom Oracle Concurrent Program target.

2.12.1 Status

This metric specifies whether the target is up and running.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

0

Database is down

2.13 Running Requests

This metric category provides information about the requests that are being run.

2.13.1 Concurrent Manager

This metric displays the name of the concurrent manager associated with the running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.13.2 Concurrent Program Name

This metric displays the name of the concurrent program associated with the running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.13.3 Concurrent Program Short Name

This metric displays the short name of the concurrent program associated with the running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.13.4 Phase

This metric displays the phase of the running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.13.5 Request Id

This metric displays the ID associated with the running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.13.6 Request Start Date

This metric displays the start date of the running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.13.7 Running Time

This metric displays the length of time that the concurrent request is running.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

Request %request_id% Running for %value% Minutes

2.13.8 Status

This metric displays the status of the running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.13.9 Username

This metric displays the user name associated with the running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.14 Tolerance Level For Long Running Request

This metric category provides information about tolerance levels for long-running requests. Tolerance level is calculated as a percentage of the running time to that of the average running time of all requests processed by this manager. This allows you to set an alert if the running time of a request exceeds a certain percentage of the average run time.

2.14.1 Concurrent Manager

This metric displays the name of the concurrent manager associated with the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.14.2 Concurrent Program Name

This metric displays the name of the concurrent program associated with the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.14.3 Concurrent Program Short Name

This metric displays the short name of the concurrent program associated with the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.14.4 Phase

This metric displays the request phase of the long-running request

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.14.5 Request Id

This metric displays the ID associated with the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.14.6 Request Start Date

This metric displays the start date of the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.14.7 Running Time

This metric displays the length of time that the request is running

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.14.8 Status

This metric displays the status of the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.14.9 Tolerance on Average Execution Time(%)

This metric displays the percentage of the running time to that of the average running time.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

Request %request_id% is Running %value%% Longer Than The Average Execution Time

2.14.10 Username

This metric displays the user name associated with the long-running request

Target Version

Collection Frequency

All Versions

Every 60 Minutes

2.15 Unscheduled Requests

This metric category provides information about unscheduled requests.

2.15.1 Concurrent Program Name

This metric displays the name of the concurrent program associated with the unscheduled request.

Target Version

Collection Frequency

All Versions

Every Day

2.15.2 Concurrent Program Short Name

This metric displays the short name of the concurrent program associated with the unscheduled request.

Target Version

Collection Frequency

All Versions

Every Day

2.15.3 Repeating schedule Request

This metric checks if a concurrent program is scheduled or not. If you set the threshold as 0, then this means that the concurrent program is not scheduled and Enterprise Manager raises an alert.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every Day

Not Defined

Not Defined

The concurrent program %program_display_name% is not scheduled.

Datasource

The FND_CONCURRENT_REQUESTS table contains an entry if a concurrent program is scheduled.

User Action

Schedule the program.

3 Forms Listener for EBS R12

This chapter describes the metrics defined for the Forms Listener for Oracle E-Business Suite Release 12.

For more information about the Forms Listener, see your Oracle E-Business Suite user documentation.

3.1 Forms Middle-Tier Processes

This metric category provides information about forms sessions and the amount of resources consumed.

3.1.1 CPU Utilization by Forms mid-tier Processes (%)

This metric displays the percentage of CPU used by the Forms mid-tier processes.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 10 Minutes

80

95

CPU Utilization for Process ID %keyValue% is %value%%%

User Action

Identify the processes that are consuming the most CPU and take appropriate action.

3.1.2 IP Address

This metric displays the IP address.

Target Version

Collection Frequency

All Versions

Every 10 Minutes

3.1.3 Memory Utilization by Forms mid-tier Processes(%)

This metric displays the percentage of memory used by the Forms mid-tier processes.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 10 Minutes

80

95

Memory Utilization for Process ID %keyValue% is %value%%%

User Action

Identify the processes that are consuming the most memory and take appropriate action.

3.1.4 Process ID

This metric displays the process ID associated with the Forms mid-tier process.

Target Version

Collection Frequency

All Versions

Every 10 Minutes

3.1.5 User Name

This metric displays the user name associated with the Forms mid-tier processes.

Target Version

Collection Frequency

All Versions

Every 10 Minutes

3.2 Load

This metric category provides information about the present load generated by the Forms processes.

3.2.1 Number of Forms Processes

This metric displays the number of Forms processes.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

3.2.2 Total CPU Utilization (%)

This metric displays the total percentage of CPU used by the Forms processes.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 5 Minutes

80

95

CPU Utilization is %value%%%

User Action

Identify the processes that are consuming the most CPU and take appropriate action.

3.2.3 Total Memory Utilization (%)

This metric displays the total percentage of memory used by the Forms processes.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 5 Minutes

80

95

Memory Utilization is %value%%%

User Action

Identify the processes that are consuming the most memory and take appropriate action.

3.3 Response

This metric category checks the status of the target.

3.3.1 Status

This metric checks if the Forms service is up and running on the Oracle E-business Suite side.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 5 Minutes

Not Defined

0

Forms Server is down (Status=%value%)

User Action

If the target is down, then check the log file to locate the reason.

4 Forms Listener for Oracle Applications 11i

This chapter describes the metrics defined for the Forms Listener for Oracle Applications 11i.

For more information about the Forms Listener, see your Oracle Applications 11i user documentation.

4.1 Forms Middle-Tier Processes

This metric category provides information about the amount of resources consumed by all the Forms sessions.

4.1.1 CPU Utilization by Forms mid-tier Processes (%)

This metric displays the percentage of CPU used by the Forms mid-tier processes.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 10 Minutes

80

95

CPU Utilization for Process ID %keyValue% is %value%%%

User Action

Identify the processes that are consuming the most CPU and take appropriate action.

4.1.2 IP Address

This metric displays the IP address.

Target Version

Collection Frequency

All Versions

Every 10 Minutes

4.1.3 Memory Utilization by Forms mid-tier Processes(%)

This metric displays the percentage of memory used by the Forms mid-tier processes.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 10 Minutes

80

95

Memory Utilization for Process ID %keyValue% is %value%%%

User Action

Identify the processes that are consuming the most memory and take appropriate action.

4.1.4 Process ID

This metric displays the process ID associated with the Forms mid-tier processes.

Target Version

Collection Frequency

All Versions

Every 10 Minutes

4.1.5 User Name

This metric displays the user name associated with the Forms mid-tier processes.

Target Version

Collection Frequency

All Versions

Every 10 Minutes

4.2 Load

This metric category provides information about the present load generated by the Forms processes.

4.2.1 Number of Forms Processes

This metric displays the number of Forms processes.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

4.2.2 Total CPU Utilization (%)

This metric displays the total percentage of CPU used by the Forms processes.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 5 Minutes

80

95

CPU Utilization is %value%%%

User Action

Identify the processes that are consuming the most CPU and take appropriate action.

4.2.3 Total Memory Utilization (%)

This metric displays the total percentage of memory used by the Forms processes.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 5 Minutes

80

95

Memory Utilization is %value%%%

User Action

Identify the processes that are consuming the most memory and take appropriate action.

4.3 Response

This metric category checks the status of the target.

4.3.1 Status

This metric checks if the Forms service is up and running on the Oracle E-Business Suite side.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 5 Minutes

Not Defined

0

Forms Server is down (Status=%value%)

User Action

If the target is down, then check the log file any reasons.

5 HTTP Server for Oracle Applications 11i

This chapter provides information about the metrics defined for the HTTP Server for Oracle Applications 11i target.

For more information about the HTTP Server component for Oracle Applications 11i, see your Oracle E-Business Suite documentation.

5.1 Host Metrics

This metric category provides the host information about where the HTTP server is running.

5.1.1 Name

This metric displays the name of the host.

5.2 Process Metrics

This metric category provides the HTTP instance information along with the host on which the HTTP Server is running.

5.2.1 Host

This metric displays the name of the host.

5.2.2 Name

This metric displays the name of the process.

5.3 Response

This metric category checks the status of the target.

5.3.1 Homepage Download, Milliseconds

This metric provides the home page download time.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.3.2 Status

This metric checks if the target is up and running.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

User Action

If the target is down, then check the log file to locate the reason for the actual cause.

5.4 dms_cProcessInfo Metrics

This metric category contains metrics about the Dynamic Monitoring Service (DMS) processes.

5.4.1 Full Name

This metric displays the full name of the process.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.4.2 Host

This metric displays the name of the host.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.4.3 Name

This metric displays the name of the process.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.4.4 Process

This metric displays the name of the process.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.4.5 cpuTime.value, msecs

This metric displays the amount of CPU time used by the process.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.4.6 heapSize.value, kilobytes

This metric displays the heap size of the process.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 5 Minutes

Not Defined

51200

User Action

Check if there are multiple HTTP processes being spawned at the operating system (OS) level.

5.4.7 host.value

This metric displays the value of the host.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.4.8 pid.value

This metric displays the value of the Process Identifier (PID).

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.4.9 totMem.value

This metric displays the value of the total physical memory used by the process.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.4.10 upTime.value, msecs

This metric displays the amount of time (in milliseconds) that the process has been up and running.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.5 ohs_module Metrics

This metric category provides information about the Oracle HTTP Server (OHS) modules.

5.5.1 Full Name

This metric displays the full name of the module.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.5.2 Host

This metric displays the name of the host.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.5.3 Name

This metric displays the name of the OHS module.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.5.4 Process

This metric displays the name of the server process.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.5.5 decline.count, ops

This metric displays the number of requests declined.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.5.6 handle.active, threads

This metric shows the number of requests currently being processed by this module's handler.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 5 Minutes

Not Defined

Not Defined

User Action

No generic action

5.5.7 handle.avg, usecs

This metric displays the average time required for this module.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.5.8 handle.completed

This metric displays the number of requests handled by this module.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.5.9 handle.currentProcessingTime, seconds

This metric displays the current processing time for requests handled by this module.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.5.10 handle.currentThroughput, requests/sec

This metric displays the current throughput for requests per second handled by this module.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.5.11 handle.maxTime, usecs

This metric displays the maximum time spent in the module handler.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.5.12 handle.minTime, usecs

This metric displays the minimum time spent in the module handler.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.5.13 handle.time, usecs

This metric displays the total time spent in the module handler.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.5.14 ohs_server

This metric displays the name of the Oracle HTTP server.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6 ohs_server Metrics

This metric category provides information about the Oracle HTTP Server.

5.6.1 Full Name

This metric displays the full name of the Oracle HTTP Server.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.2 Host

This metric displays the host name.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.3 Name

This metric displays the name of the module.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.4 Process

This metric displays the name of the process.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.5 childFinish.count, ops

This metric displays the number of child processes that finish.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.6 childStart.count, ops

This metric displays the number of child processes that start.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.7 connection.active, threads

This metric shows the number of open HTTP connections.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 5 Minutes

Not Defined

50

User Action

No generic action.

5.6.8 connection.avg, usecs

This metric displays the average time spend servicing HTTP connections.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.9 connection.completed

This metric displays the number of times an HTTP connection was established.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.10 connection.currentTime, seconds

This metric shows the average time (in seconds) a connection was open during the last collection interval. A connection remains open until all of the requests that it is handling have been completed.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 5 Minutes

Not Defined

100

User Action

No generic action.

5.6.11 connection.maxTime, usecs

This metric displays the maximum time spent servicing any HTTP connection.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.12 connection.minTime, usecs

This metric displays the minimum time spent servicing any HTTP connection.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.13 connection.time, usecs

This metric displays the total time spent servicing HTTP connections.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.14 handle.active, threads

This metric displays the child servers currently in the handle processing phase.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.15 handle.avg, usecs

This metric displays the average time spent in the module handler.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.16 handle.completed

This metric displays the number of times the handle processing phase has completed.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.17 handle.maxTime, usecs

This metric displays the maximum time spent in the module handler.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.18 handle.minTime, usecs

This metric displays the minimum time spent in the module handler.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.19 handle.time, usecs

This metric displays the total time spent in the module handler.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.20 internalRedirect.count, ops

This metric displays the number of times a module redirected a request to a new internal URI.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.21 numMods.value

This metric displays the number of loaded modules.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.22 request.active, threads

This metric displays the number of child servers currently in the request processing phase.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 5 Minutes

Not Defined

50

5.6.23 request.avg, usecs

This metric displays the average time required to service a HTTP request.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.24 request.completed

This metric displays the number of HTTP requests completed.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.25 request.currentProcessingTime, seconds

This metric shows the average time it took to process a request during the last interval. The interval is the period of time specified as the collection frequency for this metric.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 5 Minutes

Not Defined

2

User Action

No generic action

5.6.26 request.currentThroughput, requests/sec

This metric shows the number of requests per second serviced during the last interval. The interval is the period of time specified as the collection frequency for this metric.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 5 Minutes

Not Defined

100

User Action

No generic action

5.6.27 request.maxTime, usecs

This metric displays the maximum time required to service a HTTP request.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.28 request.minTime, usecs

This metric displays the minimum time required to service a HTTP request.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

5.6.29 request.time, usecs

This metric displays the total time required to service HTTP requests.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

6 Oracle Applications JVM Usage

The Oracle Applications JVM Usage target monitors the Oracle Applications Java Virtual Machines (JVMs).

6.1 Application Modules Count

This metric category indicates the number of active Oracle Application Framework pages that are currently being accessed by users.

6.1.1 Application Module Pools

This metric displays the number of Application Module pool instances.

Target Version

Collection Frequency

All Versions

Every 60 Seconds

6.1.2 Total Application Modules

This metric displays the total number of application modules.

Target Version

Collection Frequency

All Versions

Every 60 Seconds

6.1.3 Total Locked Application Modules

This metric displays the total number of locked application modules.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 60 Seconds

Not Defined

Not Defined

User Action

Administrators can review the profile options related to the Application Module Pool and check whether they are set at optimal levels.

6.2 Cached Objects

This metric category provides information about the present load generated by the Forms processes.

6.2.1 Total Cached Components

This metric displays the registered cache components in the system.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 60 Seconds

Not Defined

Not Defined

User Action

Clear cache using Functional Administrator Responsibility. For more information, see your Oracle E-Business Suite System Administrator's Guide.

6.2.2 Total Objects

This metric displays the total number of objects contained in the component cache.

Target Version

Collection Frequency

All Versions

Every 60 Seconds

User Action

Identify the processes that are consuming the most CPU and take appropriate action.

6.3 Locked/Leaked AOL/J Connections

This metric category lists the number of locked and leaked Java Database Connectivity (JDBC) connections.

6.3.1 Leaked AOL/J Connections

This metric displays the number of leaked JDBC connections utilized by applications.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 60 Seconds

Not Defined

Not Defined

User Action

Enable connection leak diagnostics

6.3.2 Locked AOL/J Connections

This metric displays the number of locked JDBC connections utilized by applications.

Target Version

Collection Frequency

All Versions

Every 60 Seconds

User Action

Review the AOLJ connection pool size and increase if necessary.

6.4 OC4J JVM Instance Metrics

This metric category provides information about the Oracle Containers for J2EE (OC4J) JVM instance.

6.4.1 OC4J JVM - Active Threads

This metric displays the number of threads currently executing in the JVM.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

User Action

No generic action.

6.4.2 OC4J JVM - CPU Usage (%)

This metric displays the percentage of CPU currently being used by the OC4J JVM instance.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

6.4.3 OC4J JVM - Memory Usage (MB)

This metric displays the amount of memory currently being used by the OC4J JVM instance.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

6.4.4 OC4J JVM Instance - Aborted Transactions

This metric displays the number of transactions that were terminated for this OC4J JVM instance.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

6.4.5 OC4J JVM Instance - Active EJB Methods

This metric displays the number of Enterprise Java Beans (EJB) methods that are currently being executed by the OC4J JVM instance.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

6.4.6 OC4J JVM Instance - Active Requests

This metric displays the number of servlets and JavaServer Pages (JSPs) currently being executed by the OC4J JVM instance.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

6.4.7 OC4J JVM Instance - Active Sessions

This metric displays the number of active HTTP sessions used by the OC4J JVM instance.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

6.4.8 OC4J JVM Instance - Active Transactions

This metric displays the number of transactions that are currently open for this OC4J JVM instance.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

6.4.9 OC4J JVM Instance - Committed Transactions

This metric displays the number of transactions that are committed for this OC4J JVM instance.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

6.4.10 OC4J JVM Instance - EJB Method Execution Rate (per second)

This metric displays the rate at which the EJB methods are currently being executed by this OC4J JVM instance during the last collection interval.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

6.4.11 OC4J JVM Instance - EJB Method Execution Time (seconds)

This metric displays the time consumed to execute EJB methods for this OC4J JVM instance during the last collection interval.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

6.4.12 OC4J JVM Instance - Heap Usage (MB)

This metric displays the amount of heap space used by the OC4J JVM instance.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

6.4.13 OC4J JVM Instance - Open JDBC Connections

This metric displays the number of JDBC open by applications that are part of this OC4J JVM instance.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

6.4.14 OC4J JVM Instance - Request Processing Time (seconds)

This metric displays the average time consumed to execute servlets and JSPs for this OC4J JVM instance during the last collection interval.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

6.4.15 OC4J JVM Instance - Requests Per Second

This metric displays the rate at which servlets and JSPs are being invoked for this OC4J JVM instance during the last collection interval.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

6.4.16 OC4J JVM Instance - Start Time (ms since Epoch)

This metric displays the time when the OC4J JVM instance was started. It is represented in milliseconds since the UNIX epoch (that is, January 1, 1970).

Target Version

Collection Frequency

All Versions

Every 5 Minutes

6.4.17 OC4J JVM Instance - Total JDBC Connections

This metric displays the total number of JDBC connections that are part of this OC4J JVM instance.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

6.5 Response

This metric category provides information about the status of the Oracle Applications JVM Usage target.

6.5.1 Status

This metric checks if the target is up and running.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Minute

Not Defined

0

Oracle Applications JVM Usage is down

User Action

If the target is down, then check the log files and take appropriate action if it is down unexpectedly.

7 Oracle Concurrent Processing

An Oracle concurrent manager is a process manager that coordinates the processes generated by users' requests to run various data-intensive programs. An Oracle E-Business Suite product group can have several concurrent managers.

For more information about Oracle concurrent processing, see your Oracle E-Business Suite documentation.

- Active Concurrent Requests by Application

- Activity

- Capacity Utilization of Concurrent Managers

- Concurrent Requests in Blocked State

- No. of Hourly Completed Requests by Status

- No of Incomplete Requests by Status

- Pending Requests (Standby)

- Pending Requests (Normal)

- Running Requests

- No of Concurrent Requests in Blocked State

- Tolerance Level For Long Running Request

- Running Request Sets

- Failed Request Sets

- Not Started Request Sets

- Unscheduled Request Sets

7.1 Active Concurrent Requests by Application

This metric category collects information about active concurrent requests by application.

Data Source

This metric is computed by counting the total active concurrent requests by application from the FND_CONCURRENT_REQUESTS table.

7.1.1 Application Name

This metric displays the name of the application.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

7.1.2 Application Short Name

This metric displays the short name of the application.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

7.1.3 Non-Repeating Pending requests (Normal and Standby)

This metric displays the number of nonrepeating pending requests (both normal and standby status).

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

Number of Non Repeating Pending Requests for application %application_name% is %value%

User Action

If there are an unusually high number of pending requests, then check if all the concurrent managers are active.

7.1.4 Non-Repeating Running requests

This metric displays the number of nonrepeating running requests.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

Number of Non Repeating Running Requests for application %application_name% is %value%

7.1.5 Repeating Pending requests (Normal and Standby)

This metric displays the number of repeating pending requests (both normal and standby status).

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

Number of Repeating Pending Requests for application %application_name% is %value%

User Action

If there are an unusually high number of pending requests, then check if all the concurrent managers are active.

7.1.6 Repeating Running requests

This metric displays the number of repeating running requests.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

Number of Repeating Running Requests for application %application_name% is %value%

7.2 Activity

This metric category provides information about active concurrent requests.

Data Source

These metrics are computed by counting the total active concurrent requests by application from the FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROCESSES and FND_LOGIN_RESP_FORMS tables.

7.2.1 Active Service Processes

This metric displays the number of active service processes.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

7.2.2 Concurrent Requests Running

This metric displays the number of concurrent requests running.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

7.3 Capacity Utilization of Concurrent Managers

This metric category compares the number of instances of concurrent managers running to that of the maximum number allowed and gets the capacity as a percentage of maximum number allowed. This is calculated for all types of concurrent managers such as Concurrent Manager, Internal Concurrent Manager and so on. You can set an alert if the capacity utilization of concurrent managers drops below a specific threshold.

Data Source

The number of instances per manager and the maximum instances allowed per manager is obtained from FND_CONCURRENT_QUEUES and the percentage is calculated.

7.3.1 Manager Name

This metric displays the name of the concurrent manager.

Target Version

Collection Frequency

All Versions

Every 1 Day

7.3.2 Utilized Capacity

This metric displays the utilized capacity for all the concurrent managers.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Day

Not Defined

Not Defined

Utilized Capacity of manager %manager_name%: %value%%

7.4 Concurrent Requests in Blocked State

This metric category provides information about concurrent requests that are in blocked state (such as row locks).

You can set an alert to inform you if a request is in blocked state for more than a specific threshold.

7.4.1 Blocking Action

This metric displays the blocking action.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.4.2 Blocking ID

This metric displays the blocking ID.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.4.3 Blocking Inst. Id

This metric displays the instance ID of the blocking concurrent program as available from the GV$LOCK view.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.4.4 Blocking Minutes

This metric displays the blocking minutes.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

Concurrent Request %request_id% Blocked for %value% Minutes

7.4.5 Blocking Module

This metric displays the blocking module.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.4.6 Concurrent Program Name

This metric displays the name of the concurrent program.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.4.7 Concurrent Request Inst. Id

This metric displays the ID associated with the concurrent request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.4.8 Concurrent Request SID

This metric displays the database SID associated with this concurrent request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.4.9 Request ID

This metric collects information on requests in blocked state (such as row locks) for a specific concurrent manager.

You can set an alert to inform you if a request is in blocked state for more than a specific threshold.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

Data Source

Blocked requests are identified by joining FND_CONCURRENT_REQUESTS with GV$LOCK and GV$SESSION when the phase code of the request is 'R' for this concurrent manager.

User Action

Analyze the cause of the block and ensure that the issue is not widespread rather than just the concurrent request.

7.5 No. of Hourly Completed Requests by Status

This metric category provides the number of requests completed in the last hour grouped based on status.

7.5.1 Concurrent Requests Completed Successfully

This metric displays the number of concurrent requests that completed successfully in the last hour.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.5.2 Concurrent Requests Completed With Error

This metric displays the number of concurrent requests that completed with an error in the last hour.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

%value% concurrent requests completed with error

7.5.3 Concurrent Requests Completed With Warning

This metric displays the number of concurrent requests that completed with a warning in the last hour.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

%value% concurrent requests completed with warning

7.5.4 Concurrent Requests Error Rate (%)

This metric displays the percentage of completed concurrent requests with errors.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

0

Not Defined

Concurrent Requests completion with error rate is %value%%%

7.5.5 Concurrent Requests Successful Requests Rate (%)

This metric displays the percentage of successfully completed concurrent requests.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

Concurrent Requests sucessful completion rate is %value%%%

7.5.6 Concurrent Requests Warning Rate (%)

This metric displays the percentage of completed concurrent requests with warnings.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

Concurrent Requests completion with warning rate is %value%%%

7.6 No of Incomplete Requests by Status

This metric category provides the number of incomplete requests which are in various stages of progress, grouped by status.

7.6.1 Concurrent Requests Inactive (No Manager)

This metric displays the number of incomplete inactive concurrent requests with a status of No Manager.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

value% Concurrent Requests are Inactive (No Manager)

7.6.2 Concurrent Requests Inactive (On Hold)

This metric displays the number of incomplete inactive concurrent requests with a status of On Hold.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

%value% Concurrent Requests are on hold

7.6.3 Concurrent Requests Pending (Normal)

This metric displays the number of incomplete pending concurrent requests with a status of Normal.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

%value% Concurrent Requests are Pending (Normal)

7.6.4 Concurrent Requests Pending (Standby)

This metric displays the number of incomplete pending concurrent requests with a status of Standby.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

%value% Concurrent Requests are Pending (Standby)

7.6.5 Concurrent Requests Running

This metric displays the number of running concurrent requests.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

7.6.6 Concurrent Requests Scheduled

This metric displays the number of scheduled concurrent requests.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

7.7 Pending Requests (Standby)

This metric category provides informations about requests in a pending phase with a status of Standby.

7.7.1 Concurrent Program Name

This metric displays the name of the concurrent programs associated with the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.7.2 Concurrent Program Short Name

This metric displays the short name of the concurrent program associated with the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.7.3 Phase

This metric displays the request phase of the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.7.4 Request Id

This metric displays the ID associated with the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.7.5 Request Start Date

This metric displays the start date of the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.7.6 Standby Pending Time

This metric displays the length of time that the request is pending with a status of Standby.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

Request %request_id% Pending in Standby Status for %value% Minutes

7.7.7 Status

This metric displays the status of the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.8 Pending Requests (Normal)

This metric category provides information about requests in a pending phase with a status of Normal.

7.8.1 Concurrent Program Name

This metric displays the name of the concurrent program associated with the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.8.2 Concurrent Program Short Name

This metric displays the short name of the concurrent program associated with the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.8.3 Normal Pending Time

This metric displays the length of time that the request is pending in a Normal Status.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

Request %request_id% Pending in Normal Status for %value% Minutes

7.8.4 Phase

This metric displays the request phase of the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.8.5 Request Id

This metric displays the ID associated with the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.8.6 Request Start Date

This metric displays the start date of the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.8.7 Status

This metric displays the status of the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.8.8 Username

This metric displays the user name associated with the pending request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.9 Running Requests

This metric category provides information about requests that are running.

7.9.1 Concurrent Program Name

This metric displays the name of the concurrent program associated with the running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.9.2 Concurrent Program Short Name

This metric displays the short name of the concurrent program associated with the running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.9.3 Phase

This metric displays the phase of the running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.9.4 Request ID

This metric displays the ID associated with the running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.9.5 Request Start Date

This metric displays the start date of the running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.9.6 Running Time

This metric displays the length of time that the concurrent request is running.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

Request %request_id% Running for %value% Minutes

7.9.7 Status

This metric displays the status of the running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.9.8 Username

This metric displays the user name associated with the running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.10 No of Concurrent Requests in Blocked State

This metric category provides information about the number of requests that are in a blocked state because of database locks.

7.10.1 Concurrent Program Name

This metric displays the name of the concurrent program.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.10.2 No of Concurrent Requests in Blocked State

This metric displays the number of requests that are in a blocked state because of database locks.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

No of Concurrent Requests in Blocked State

7.11 Tolerance Level For Long Running Request

This metric category provides information about tolerance levels for long running requests. Tolerance level is calculated as a percentage of the running time to that of the average running time. This enables you to set an alert if the running time of a request exceeds a certain percentage of the average run time.

7.11.1 Concurrent Manager

This metric displays the name of the concurrent manager associated with the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.11.2 Concurrent Program Name

This metric displays the name of the concurrent program associated with the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.11.3 Concurrent Program Short Name

This metric displays the short name of the concurrent program associated with the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.11.4 Phase

This metric displays the request phase of the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.11.5 Request ID

This metric displays the ID associated with the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.11.6 Request Start Date

This metric displays the start date of the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.11.7 Running Time

This metric displays the length of time that the request is running.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.11.8 Status

This metric displays the status of the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.11.9 Tolerance on Average Execution Time (%)

This metric displays the percentage of the running time to that of the average running time.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

Request %request_id% is Running %value%% Longer Than The Average Execution Time

7.11.10 Username

This metric displays the user name associated with the long-running request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.12 Running Request Sets

This metric category provides information about the running request sets. Request sets are defined to run several concurrent programs in a single request.

7.12.1 Concurrent Request Set Name

This metric displays the name of the concurrent request set.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.12.2 Phase

This metric displays the phase of the running request set.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.12.3 Request Id

This metric displays the ID associated with the running request set.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.12.4 Requested Start Date

This metric displays the start date of the running request set.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.12.5 Running Time

This metric displays the length of time that the request set is running.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

Request %request_id% Running for %value% Minutes

7.12.6 Status

This metric displays the status of the running request set.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.13 Failed Request Sets

This metric category provides information about the failed request sets.

7.13.1 Concurrent Request Set Name

This metric displays the name of the concurrent request set.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Not Defined

Failed Request Set name is %value%

7.13.2 Execution Time

This metric displays the length of time it took to complete the failed request set.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.13.3 Phase

This metric displays the phase of the failed request set.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.13.4 Request ID

This metric displays the ID associated with the failed request set

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.13.5 Requested Start Date

This metric displays the start date of the failed request set.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.13.6 Status

This metric displays the status of the failed request set.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.13.7 User Name

This metric displays the user name associated with the failed request set.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

7.14 Not Started Request Sets

This metric category provides information about the request sets that have not started yet.

7.14.1 Concurrent Queue Name

This metric displays the name of the Concurrent Manager queue.

Target Version

Collection Frequency

All Versions

Every 20 Minutes

7.14.2 Concurrent Request Set Name

This metric displays the name of the concurrent request set.

Target Version

Collection Frequency

All Versions

Every 20 Minutes

7.14.3 Request Id

This metric displays the ID associated with the request set that has not started yet.

Target Version

Collection Frequency

All Versions

Every 20 Minutes

7.14.4 Requested Start Date

This metric displays the start date of the request set that has not started yet.

Target Version

Collection Frequency

All Versions

Every 20 Minutes

7.14.5 Status

This metric displays the status of the request set that has not started yet.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 20 Minutes

Not Defined

Not Started

Request Set %request_id% is not started since %requested_start_date%

7.14.6 User Name

This metric displays the user name associated the request set that has not started yet.

Target Version

Collection Frequency

All Versions

Every 20 Minutes

7.14.7 Wait Time

This metric displays the length of time the request set waits to be processed.

Target Version

Collection Frequency

All Versions

Every 20 Minutes

7.15 Unscheduled Request Sets

This metric category provides information about the request sets that are yet to be scheduled.

7.15.1 Concurrent Request Set Name

This metric displays the name of the concurrent request set.

Target Version

Collection Frequency

All Versions

Every 24 Hours

7.15.2 Request Id

This metric displays the ID associated with the request set that has to be scheduled.

Target Version

Collection Frequency

All Versions

Every 24 Hours

7.15.3 Status

This metric displays the status of the request set that has to be scheduled.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 24 Hours

Not Defined

Unscheduled

Request Set %request_id% is Unscheduled

8 Oracle E-Business Suite

Oracle E-Business Suite is a complete set of business applications for managing and automating processes across your enterprise.

- Abandoned Nodes

- Activity

- Applications System Status

- Applications by Errored Execs

- Applications by Pending Requests

- Concurrent Managers Configured

- Configuration Changes (Last 24 hours)

- Forms Database Sessions per Application

- Native Services

- Oracle Applications Internal System Alerts

- Processes and Requests per Concurrent Manager

- Programs by Average Running Time

- Programs by Errored Executions

- Programs by Executions

- Programs by Total Running Time

- Response

- Top Pending Requests

- Top Running Requests

- Top Scheduled Requests

- Top Users (Requests Submitted)

- Users by Pending Requests

- Users by Running Requests

- Web Users

- Workflow Agent Activity

- Workflow Notifications

8.1 Abandoned Nodes

During online patching, patching can fail on some nodes. You can mark this node as abandoned and proceed with the completion of the patching cycle. This metric category collects the list of abandoned nodes and raises an incident. For an abandoned node, you must first customize the discovery and disable this node and then do a rediscovery. For more information about discovery, see the Oracle Enterprise Manager Cloud Control Administrator's Guide.

8.1.1 Node Name

This metric displays the name of the node with the failed online patching.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

8.1.2 Node Type

This metric displays the type of node with the failed online patching.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

8.1.3 Status

This metric displays the status of the node and raises an incident if the node is marked as Abandoned.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

Abandoned

Node %node_name% is abandoned. Please exclude this node from discovery customization and rerun EBS discovery.

8.2 Activity

This metric category provides information about active service processes, active concurrent requests, and active Forms sessions.

Data Source

The metrics in this category are computed by counting total active concurrent requests by application from FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROCESSES and FND_LOGIN_RESP_FORMS.

8.2.1 Active Service Processes

This metric displays the total number of processes running for the concurrent manager.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.2.2 Concurrent Requests Running

This metric displays the active running concurrent requests.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.2.3 Forms Sessions

This metric displays the active Forms sessions.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.3 Applications System Status

This metric category shows the application system status. These metrics are collected for generating various charts for performance and usage.

8.3.1 Apps Metric Type

This metric displays the type of Applications metric.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.3.2 Host Name

This metric displays the host name.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.3.3 Host Platform

This metric displays the host's operating system.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.3.4 Last Update Date

This metric displays the date of the last update.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.3.5 Metric Name

This metric displays the name of the metric.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.3.6 Service Description

This metric displays a description of this service.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.3.7 Service Name

This metric displays the name of this service.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.3.8 Service Status Code

This metric displays the status code associated with this service.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.3.9 Service Type

This metric displays the type of this service.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.4 Applications by Errored Execs

This metric category is used to send alerts when errors executions exceed certain limits set by users. These metrics are important to understand failure rate as well as using total exceutions for capacity planning.

Data Source

The metrics in this metric category are computed by counting errored executions from FND_CONCURRENT_REQUESTS.

8.4.1 Application Name

This metric displays the name of the application.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.4.2 Application Short Name

Target Version

Collection Frequency

All Versions

Every 1 Day

This metric displays the short name of the application.

8.4.3 Errored Executions

This metric displays the number of errored executions.

You can set the threshold to monitor errored executions of concurrent programs.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every1 Day

Not Defined

0

%value%

User Action

Investigate all the errored concurrent process executions.

8.4.4 Errored Executions (%)

This metric displays the percentage of errored executions.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.4.5 Node Name

This metric displays the name of the node.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.4.6 Total Executions

This metric displays the total number of executions.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.5 Applications by Pending Requests

This metric category shows all the pending concurrent requests by application.

8.5.1 Application Name

This metric displays the name of the application.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.5.2 Application Short Name

This metric displays the short name of the application.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.5.3 Number of Pending Requests

This metric displays the number of pending concurrent requests.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Day

Not Defined

Not Defined

%value%

Data Source

This metric is computed by counting pending concurrent processing requests from FND_CONCURRENT_REQUESTS.

User Action

If a large number of concurrent requests are pending, then make sure the concurrent manager is up and running or else consider adding more concurrent managers.

8.6 Concurrent Managers Configured

This metric category provides information about the number of configured concurrent managers.

8.6.1 Number of Configured Concurrent Managers

This metric shows the number of concurrent managers configured.

Target Version

Collection Frequency

All Versions

Every 1 Day

Data Source

FND_CONCURRENT_REQUESTS

8.7 Configuration Changes (Last 24 hours)

This metric indicates if the configuration has changed in the last 24 hours.

8.7.1 Context Files Edited

This metric displays the number of context files that have changed on the system in the last 24 hours. Changes made to context files can impact your overall processing configuration and the functioning of business processes.

If you want to get notified about these configuration changes, then set this threshold.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Hour

Not Defined

Not Defined

%value% context files have been edited in the last 24 hours

User Action

Use this data to help diagnose sudden changes in the functioning of your applications system.

8.7.2 Invalid Database Objects

This metric displays the list of invalid objects owned by the APPS schema.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Hour

Not Defined

Not Defined

%value% invalid objects found

User Action

Use this data to help diagnose sudden changes in the functioning of your applications system.

8.7.3 Last Update Date

This metric displays the date of the last update.

Target Version

Collection Frequency

All Versions

Every 1 Hour

8.7.4 Patches Applied

This metric displays the list of patches that have been applied to the system in the last 24 hours.

Target Version

Collection Frequency

All Versions

Every 1 Hour

User Action

Use this data to help diagnose sudden changes in the functioning of your applications system.

8.7.5 Site Level Profile Options Changed

This metric displays the number of site level profile options that have changed on the system in the last 24 hours.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Hour

Not Defined

Not Defined

%value% site level profile options have changed in the last 24 hours

User Action

Use this data to help diagnose sudden changes in the functioning of your applications system.

8.8 Forms Database Sessions per Application

This metric category provides information about the Forms database sessions for a selected application.

8.8.1 Application Name

This metric displays the name of the application.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.8.2 Application Short Name

This metric displays the short name of the application.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.8.3 Number of Forms Database

This metric displays the number of form sessions for each application.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

0

Not Defined

%value% Forms Database Sessions are active for Application %application_name%

Data Source

This metric is computed by counting form sessions for each application.

User Action

If the warning threshold is reached, then investigate the Oracle E-Business Suite sizing guidelines.

For more information see R12: Forms Runtime Diagnostics (FRD), Tracing And Logging For Forms In Oracle Applications (Doc ID 438652.1) on My Oracle Support:

https://support.oracle.com/

8.9 Native Services

This metric category is used to determine the status of native services. You can set the collection schedule only and not the warning or critical threshold levels.

8.9.1 Application Name

This metric displays the name of the application.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.9.2 Application Short Name

This metric displays the short name of the application.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.9.3 Service Actual Processes

This metric displays the number of service actual processes.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.9.4 Service Application Name

The metric displays the service application name.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.9.5 Service Handle

This metric displays the service handle.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.9.6 Service Message

This metric displays the service message.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.9.7 Service Name

This metric displays the name of the service

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.9.8 Service Status

This metric displays the status of the service.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

0

Not Defined

Service %srvc_name% is down.

User Action

If the services are down, investigate the cause and start up the services again.

8.9.9 Service Target Processes

This metric displays the service target processes.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.10 Oracle Applications Internal System Alerts

This metric category provides internal system alerts for users to take corrective actions

8.10.1 Last Update Date

This metric displays the date of the last update.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.10.2 New Oracle Applications System Alert Occurrences

This metric displays the number of additional occurrences of system alerts that are in a new status.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

0

Not Defined

New Oracle Applications system alert occurrences greater than %value%

User Action

You can set the threshold for New System Alert Occurrences. Check alerts and take corrective action.

8.10.3 New Oracle Applications System Alerts

This metric displays the number of system alerts that have not yet been acknowledged by the administrator. An alert is acknowledged when it is manually moved from a status of New to a status of Open or Closed.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

0

Not Defined

New Oracle Applications system alerts greater than %value%

User Action

You can set the threshold for New system alerts. Check alerts and take corrective action.

8.10.4 Open Oracle Applications System Alert Occurrences

This metric displays all occurrences of alerts that are currently open.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.10.5 New Oracle Applications System Alerts

This metric displays all the system alerts that are in an open status. An alert must be manually moved from the new to open status.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

8.11 Processes and Requests per Concurrent Manager

This metric category provides information about the processes and requests for each concurrent manager.

8.11.1 Available Processes

This metric displays the number of available processes.

Target Version

Collection Frequency

All Versions

Every 7 Minutes

8.11.2 Concurrent Manager Name

This metric displays the name of the concurrent manager.

Target Version

Collection Frequency

All Versions

Every 7 Minutes

8.11.3 Normal Pending Requests

This metric displays the number of pending requests.

Target Version

Collection Frequency

All Versions

Every 7 Minutes

8.11.4 Running Requests

This metric displays the number of running requests.

Target Version

Collection Frequency

All Versions

Every 7 Minutes

8.11.5 Standby Pending Request

This metric displays the number of standby pending requests.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 7 Minutes

Not Defined

Not Defined

User Action

You can set the threshold Standby Pending Requests (>=) and receive alerts when the warning threshold is reached. Investigate why the requests are in standby pending status. Check if any background processes are blocking the concurrent request queue.

8.12 Programs by Average Running Time

This metric category provides information about the average running time for concurrent programs.

8.12.1 Average Running Time

This metric displays the average running time for the concurrent program.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Day

Not Defined

Not Defined

%value%

User Action

You can set the threshold for this metric for all the concurrent requests. If the concurrent programs average time reaches the threshold, that is, exceeds the average running time, then alerts are generated. If the average running time exceeds the threshold, then investigate the cause.

8.12.2 Concurrent Program Name

This metric displays the internal name of the concurrent program.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.12.3 Maximum Running Time

This metric displays the maximum running time for concurrent programs.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.12.4 Total Executions

This metric displays the total number of concurrent program executions.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.12.5 User Concurrent Program Name

This metric displays the user-friendly name of the concurrent program.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.13 Programs by Errored Executions

This metric category provides information about errored executions.

Data Source

FND_CONCURRENT_PROGRAMS table.

8.13.1 Concurrent Program Name

This metric displays the internal name of the concurrent program.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.13.2 Executions Errored (%)

This metric displays the percentage of errored executions.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.13.3 Total Executions

This metric displays the total number of executions.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.13.4 Total Executions (Errored)

This metric displays the total number of errored executions.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Day

Not Defined

Not Defined

%value%

User Action

You can set the threshold for this metric to generate alerts. Check for concurrent processing failures in Oracle E-Business Suite.

8.13.5 User Concurrent Program Name

This metric displays the user-friendly name of the concurrent program.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.14 Programs by Executions

This metric category provides information about concurrent program executions.

8.14.1 Concurrent Program Name

This metric displays the internal name of the concurrent program.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.14.2 Errored Executions (%)

This metric displays the percentage of errored executions.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Day

Not Defined

Not Defined

%value%

8.14.3 Successful Executions (%)

This metric displays the percentage of successful executions.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.14.4 Total Executions

This metric displays the total number of executions.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.14.5 User Concurrent Program Name

This metric displays the user-friendly name of the concurrent program.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.15 Programs by Total Running Time

This metric category provides information about concurrent program by total running time.

8.15.1 Concurrent Program Name

This metric displays the internal name of the concurrent program.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.15.2 Successful Executions (%)

This metric displays the percentage of successful executions.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.15.3 Total Executions

This metric displays the total number of executions.

Target Version

Collection Frequency

All Versions

Every 1 Day

User Action

This metric returns up to 10 programs that are exceeding the threshold value of the top running time set by the user.

8.15.4 Total Running Time

Target Version

Collection Frequency

All Versions

Every 1 Day

This metric displays the total running time.

8.15.5 User Concurrent Program Name

This metric displays the user-friendly name of the concurrent program.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.16 Response

This metric category provides information about the status of the target.

8.16.1 Status

This metric displays the status of the selected target, that is whether the target is up and running.

Target Version

Collection Frequency

All Versions

Event-driven

8.17 Top Pending Requests

This metric category shows the top pending requests and users can get alerts by setting thresholds for the pending time.

8.17.1 Manager Name

This metric displays the concurrent manager name.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.17.2 Pending Time

This metric returns up to a number of 10 programs that are exceeding the pending time threshold.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Day

Not Defined

Not Defined

%value%

8.17.3 Phase

This metric displays the request phase.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.17.4 Program Name

This metric displays the name of the program associated with the request.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.17.5 Program Short Name

This metric displays the short name of the program associated with the request.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.17.6 Request ID

This metric displays the ID associated with the request.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.17.7 Request Start Date

This metric displays the start date of the request.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.17.8 Status

This metric displays the status of the program.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.17.9 User Name

This metric displays the user name associated with the program.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.18 Top Running Requests

This metric category shows the top running requests.

8.18.1 Manager Name

This metric displays the concurrent manager name.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.18.2 Phase

This metric displays the request phase.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.18.3 Program Name

This metric displays the name of the program associated with the request.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.18.4 Program Short Name

This metric displays the short name of the program associated with the request.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.18.5 Request ID

This metric displays the ID associated with the request.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.18.6 Request Start Date

This metric displays the start date of the request.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.18.7 Running Time

This metric displays the running time of the program.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Day

0

Not Defined

%value%

8.18.8 Status

This metric displays the status of the program.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.18.9 User Name

This metric displays the user name associated with the program.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.19 Top Scheduled Requests

This metric category provides information about the top scheduled requests.

8.19.1 Manager Name

This metric displays the concurrent manager name.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.19.2 Phase

This metric displays the request phase.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.19.3 Program Name

This metric displays the name of the program associated with the request.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.19.4 Program Short Name

This metric displays the short name of the program associated with the request.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.19.5 Request ID

This metric displays the ID associated with the request.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.19.6 Request Start Date

This metric displays the start date of the request.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.19.7 Scheduled to Run in (Minutes)

This metric displays the number of minutes in which the program is scheduled to run.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.19.8 Status

This metric displays the status of the program.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.19.9 User Name

This metric displays the user name associated with the program.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.20 Top Users (Requests Submitted)

This metric category provides information about monitoring top users who are submitting or running more concurrent requests.

8.20.1 Number of Requests

This metric displays the number of concurrent requests submitted. If users exceed the number of requests submitted, then an alert is sent out.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 1 Day

Not Defined

Not Defined

8.20.2 User Name

This metric displays the user name associated with the concurrent requests.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.21 Users by Pending Requests

This metric category provides information about monitoring top users by pending requests.

8.21.1 Number of Pending Requests

This metric displays the number of concurrent requests pending.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 1 Day

Not Defined

Not Defined

8.21.2 User Name

This metric displays the user name associated with the pending requests.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.22 Users by Running Requests

This metric category provides information about monitoring top users by running requests.

8.22.1 Number of Running Requests

This metric displays the number of concurrent requests running.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Day

Not Defined

Not Defined

%value%

8.22.2 User Name

This metric displays the user name associated with the running requests.

Target Version

Collection Frequency

All Versions

Every 1 Day

8.23 Web Users

This metric category provides information about the number of web users.

8.23.1 Number of Web Users (Hourly)

This metric displays the number of web users each hour.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Hour

Not Defined

Not Defined

Number of Web Users last hour is %value%

8.24 Workflow Agent Activity

The Agent Activity shows the distribution of event messages with different statuses.

8.24.1 Errored Business Event System Messages

This metric displays the number of errored business event system messages.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

%value% Errored Business Event System Messages

User Action

No generic action. Contact the Oracle E-Business Suite Administrator or Oracle Support.

8.24.2 Expired Business Event System Messages

This metric displays the number of expired business event system messages.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

%value% Expired Business Event System Messages

User Action

Check the agent listeners and the database alert log.

8.24.3 Processed Business Event System Messages

This metric displays the number of processed business event system messages.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

%value% Processed Business Event System Messages

User Action

Check if the agent listeners are up and running.

8.24.4 Ready Business Event System Messages

This metric displays the number of ready business event system messages.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

%value% Ready Business Event System Messages

User Action

If the number of messages is large, then check whether the workflow agents are running and check that the workflow container services from Oracle E-Business Suite are up.

8.24.5 Undeliverable Business Event System Messages

This metric displays the number of undeliverable business event system messages.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

Not Defined

%value% Un-deliverable Business Event System Messages

User Action

No generic action. Contact the Oracle E-Business Suite Administrator or Oracle Support.

8.24.6 Waiting Business Event System Messages

This metric displays the number of waiting business event system messages.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 15 Minutes

Not Defined

Not Defined

User Action

No action.

8.25 Workflow Notifications

This metric category provides information about workflow notifications.

8.25.1 Errored Workflow Notifications

This metric displays the workflow e-mail notification status by computing the number of errored and unsent workflow notifications.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Hour

Not Defined

Not Defined

%value% errored Workflow Notifications

Data Source

This data is obtained from the WF_NOTIFICATIONS table.

User Action

Check if the e-mail address of recipient is correct and check that the SMTP server can relay e-mails to recipient's e-mail domain.

8.25.2 Unsent Workflow Notifications

This metric displays the number of unsent workflow notifications.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Hour

Not Defined

Not Defined

%value% unsent Workflow Notifications

User Action

Check if the mailer is up and running and that the outbound thread count is greater than or equal to 1.

9 Oracle E-Business Suite Conflict Resolution Manager

The Oracle E-Business Suite Conflict Resolution Manager enforces rules designed to ensure that incompatible concurrent requests do not run in the same conflict. This chapter describes the metrics available for the Conflict Resolution Manager target.

- CRM Inactive Minutes

- CRM in Blocked State in a Work Cycle

- Response

9.1 CRM Inactive Minutes

This metric category provides information in case if the conflict resolution manager is inactive for a certain period of time. You can raise alerts if continues in inactive state beyond a certain period of time

9.1.1 Concurrent Queue Name

Name of the conflict resolution manager.

Target Version

Collection Frequency

All Versions

Every 10 Minutes

9.1.2 Last Work End Date

The time when the last conflict resolution happened.

Target Version

Collection Frequency

All Versions

Every 10 Minutes

9.1.3 No. of minutes elapsed since last work end

Time since the last conflict resolution happened.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 10 Minutes

Not Defined

Not Defined

CRM is inactive since %value% minutes

9.2 CRM in Blocked State in a Work Cycle

This metric category provides information in case if the conflict resolution manager goes to blocked state. You can raise alerts if it is blocked state beyond a certain period of time.

9.2.1 Blocking Minutes

The total number of minutes for which the conflict resolution manager is in blocked state.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 10 Minutes

Not Defined

Not Defined

CRM is in blocked state in a work cycle since %value% minutes

9.2.2 Blocking Process ID

Process ID of the OS process which is blocking the conflict resolution manager.

Target Version

Collection Frequency

All Versions

Every 10 Minutes

9.2.3 Blocking Process Name

The name of the OS process which is blocking the conflict resolution manager.

Target Version

Collection Frequency

All Versions

Every 10 Minutes

9.2.4 Conflict Resolution Manager SID

The system identifier (SID) of the conflict resolution manager.

Target Version

Collection Frequency

All Versions

Every 10 Minutes

9.2.5 No. of minutes elapsed of running cycle

The number of minutes elapsed since the work cycle started.

Target Version

Collection Frequency

All Versions

Every 10 Minutes

9.3 Response

This metric category provides information about the status of the conflict resolution manager.

9.3.1 Status

This metric checks whether the target is up and running.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 5 Minutes

Not Defined

0

Concurrent Manager is down (Status=%value%)

10 Oracle E-Business Suite Node

This chapter provides descriptions for the metrics defined for the Oracle E-Business Suite Node.

- Configuration File Discrepancies

- Cutover Status

- Response

10.1 Configuration File Discrepancies

This metric category provides information about discrepancies between the context files in the file system and database. You can define a threshold to raise an alert if there are discrepancies between the context files in the file system and database.

10.1.1 Discrepancy Files

This metric specifies whether there are any discrepancies between the context files in the file system and the database.

Target Version

Collection Frequency

All Versions

Every 1 Day

10.1.2 Discrepancy Count

This metric displays the number of context files with discrepancies between the context files in the file system and the database.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 1 Day

Not Defined

0

%DISCREP_FILES%

10.2 Cutover Status

This metric category provides information about the status of the Cutover deployment procedure.

10.2.1 Cutover Status Running

This metric specifies whether the cutover process is running.

Target Version

Collection Frequency

All Versions

Every 10 Minutes

10.2.2 Cutover Status Failed

This metric specifies whether the cutover process failed.

Target Version

Collection Frequency

All Versions

Every 10 Minutes

10.2.3 Cutover Status Completed

This metric specifies whether the cutover process completed and the timestamp associated with the completion date.

Target Version

Collection Frequency

All Versions

Every 10 Minutes

10.3 Response

This metric category provides information about the status of the Oracle E-Business Suites Node target.

10.3.1 Status

This metric specifies whether the Oracle E-Business Suite Node is up and running.

Target Version

Collection Frequency

All Versions

Event-driven

11 Oracle E-Business Suite Output Post Processor

Concurrent processing uses the Output Post Processor (OPP) to enforce post-processing actions for concurrent requests. Post-processing actions are actions taken on concurrent request output. An example of a post-processing action is that used in publishing concurrent requests with XML Publisher. This chapter provides descriptions of the metrics available for the Oracle E-Business Suite Output Post Processor.

- Output Post processor Hang Error

- No. of NoResponse and Timeout Error Requests

- No Response Error Requests

- Response

- Timeout Error Requests

11.1 Output Post processor Hang Error

This metric category checks whether the output post processor is responding.

11.1.1 Error Message

This metric provides the error pattern that is the causing the output post processor not to respond.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

11.1.2 Request ID

This metric provides the request which caused the output post processor to stop responding.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

11.1.3 Request having hang error

This metric provides the number of requests having errors.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

1

Output Post processor has hanged

11.2 No. of NoResponse and Timeout Error Requests

This metric category provides the total count of no response and timeout errors.

11.2.1 No. of NoResponse Error Requests

This metric provides the total count of no response errors.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

11.2.2 Output Post processor Hang Error

This metric checks whether the output post processor is responding.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

11.2.3 Error Message

This metric provides the error pattern that is the causing the output post processor to stop responding.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

11.2.4 Request ID

This metric provides the request which caused the output post processor to stop responding.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

11.2.5 Request having hang error

This metric provides the number of requests having this error.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

1

No response from Output Post processor

11.2.6 No. of Timeout Error Requests

This metric provides the total count of timeout errors.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 60 Minutes

Not Defined

1

Request timeout from Output Post processor

11.3 No Response Error Requests

This metric category provides details of the request with no response error.

11.3.1 Error Message

This metric provides the error message for a specific request ID.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

11.3.2 Request ID

This metric provides the ID of the request that is failing with no response error.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

11.4 Response

This metric category provides information about the status of output post processor.

11.4.1 Status

This metric checks whether the target is up and running.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 5Minutes

Not Defined

0

Concurrent Manager is down (Status=%value%)

11.5 Timeout Error Requests

This metric category provides details of requests that timed out.

11.5.1 Error Message

This metric provides the error message with the details of the time out

Target Version

Collection Frequency

All Versions

Every 60 Minutes

11.5.2 Request ID

This metric provides the ID of the timed-out request.

Target Version

Collection Frequency

All Versions

Every 60 Minutes

12 Oracle MobileApps Telnet Listener

This chapter provides information about the metrics defined for the Oracle MobileApps Telnet Listener target.

- MobileApps Dispatcher Port Listening Status

- MobileApps Telnet Ports Listening Status

- Response

12.1 MobileApps Dispatcher Port Listening Status

This metric category provides information about the MobileApps Dispatcher port.

12.1.1 Listening Status

This metric displays the listening status of the dispatcher port.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 5 Minutes

Not Defined

Not Listening

Dispatcher Port (%port%) is not in Listening Status

12.1.2 Port

This metric displays the port number of the dispatcher port.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

12.1.3 Process Name

This metric displays the process name of the dispatcher process.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

12.1.4 Process Status

This metric displays the status of the dispatcher process.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 5 Minutes

Not Defined

Not Running

Dispatcher Process (%process_name%) is not running

12.2 MobileApps Telnet Ports Listening Status

This metric category provides information about the MobileApps Telnet port.

12.2.1 Listening status

This metric displays the listening status of the dispatcher port.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 5 Minutes

Not Defined

Not Listening

Telnet Port %port% is not in Listening Status

12.2.2 Port

This metric displays the port number of the dispatcher port.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

12.3 Response

This metric category provides information about the status of the target.

12.3.1 Status

This metric displays the status of the selected target, that is, whether the target is up and running.

Target Version

Collection Frequency

All Versions

Every 5 Minutes

13 Oracle Workflow Agent Listener

The Oracle Workflow Agent Listener is the target for monitoring the Oracle Workflow Agent listeners.

For more information about Oracle Workflow Agent listeners, see your Oracle Workflow user documentation.

13.1 Errored Java Events

This metric category provides information about the errored Java business events.

13.1.1 Errored Java Events

This metric displays the number of errored Java business events.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

0

Not Defined

%value% Errored Java Events

Data Source

This data is collected from the WF_JAVA_ERROR queue.

User Action

The event payload from WF_JAVA_ERROR AQ contains the detailed error stack about failed or errored events. Review the event payload and fix the problem.

Also, check if the Workflow Java Error Agent Listener is up and running. If the backlog of number of READY error events is large, then check the number of threads of the Workflow Java Error Agent Listener.

13.2 Errored PLSQL Events

This metric category provides information about errored PL/SQL business events.

13.2.1 Errored PLSQL Event

This metric displays the number of errored PL/SQL business events.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

0

Not Defined

%value% Errored PLSQL Events

Data Source

This data is collected from the WF_ERROR queue.

User Action

The event payload from the WF_ERROR AQ table contains the detailed error stack about failed or errored events. Review the event payload and fix the problem.

Also check if the Workflow Error Agent Listener is up and running. If the backlog of the number of READY error events is large, then check the number of threads of the Workflow Error Agent Listener.

13.3 Pending Java Events

This metric category provides information about deferred Java business events.

13.3.1 Pending Java Events

This metric displays the number of deferred Java business events.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

0

Not Defined

%value% Pending Java Events

Data Source

This data is collected from the WF_JAVA_DEFERRED queue.

User Action

If the backlog of READY messages is large, then check if the Workflow Deferred Java Agent Listener is up and running and that the number of threads are greater than or equal to 1.

13.4 Pending PLSQL Events

This metric provides information about the deferred PL/SQL business events.

13.4.1 Pending PLSQL Events

This metric displays the number of deferred PL/SQL events.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

0

Not Defined

%value% Pending PLSQL Events

Data Source

This data is collected from the WF_DEFERRED queue.

User Action

If the backlog of READY messages is large, then check if the Workflow Deferred Agent Listener is up and running and that the number of threads are greater than or equal to 1.

13.5 Response

This metric category checks the Oracle Workflow Agent Listener container and the following Agent Listener components when the target is up and running or down.

1. Workflow Deferred Agent Listener

2. Workflow Deferred Notification AgentListener

3. Workflow Error Agent Listener

4. Workflow Inbound Notifications Agent Listener

13.5.1 Status

This metric displays whether the target is up and running.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

DOWN

%value% Workflow Deferred Agent Listeners Running

User Action

If the status is DOWN, then check the Workflow Agent Listener.

14 Oracle Workflow Background Engine

The Oracle Workflow Background Engine target monitors the Oracle Workflow Background Engine.

- Deferred Items

- Response

14.1 Deferred Items

This metric category provides information about deferred workflow processes.

14.1.1 Deferred Items

This metric displays the number of deferred workflow processes.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

0

Not Defined

%value% Deferred Activities

Data Source

This data is collected from the WF_DEFERRED queue.

User Action

If the backlog of READY messages is very high, then check if the Workflow Background Engine concurrent program is scheduled at required intervals and the service is up and running.

The Workflow Background engine depends on the Internal Concurrent Manager (ICM), so make sure that ICM is up and running.

For more information, see the Oracle Workflow Administrator's Guide.

14.2 Response

This metric category provides information about the status of the Oracle Workflow Background Engine target.

14.2.1 Status

This metric shows the status of the Oracle Workflow Background Engine target.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

0

%value% Workflow Background Requests Running

Data Source

This data is collected from the FND_CONCURRENT_REQUESTS table.

User Action

Check if the Oracle Workflow Background Engine target is running.

15 Oracle Workflow Notification Mailer

Oracle Workflow Notification Mailer is a service component that sends e-mail notifications to users through a mail application, and processes e-mail responses.

- Pending Inbound Notification Events

- Pending Outbound Notification Events

- Pending Outbound Notifications

- Response

15.1 Pending Inbound Notification Events

This metric category provides information about pending inbound notification events.

15.1.1 Pending Inbound Notification Events

This metric displays the number of pending (ready to be processed) inbound notification events.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

0

Not Defined

%value% Pending Inbound Notification Events

Data Source

This data is collected from the WF_NOTIFICATION_IN queue.

User Action

If the READY message count is too high, then check if the Workflow Inbound Notifications Agent Listener is up and running and that the thread count is greater than or equal to 1.

Note:
You can increase the Inbound Notification Listener's thread count to improve message processing time.

15.2 Pending Outbound Notification Events

This metric category provides information about the pending outbound notification events.

15.2.1 Pending Outbound Notification Events

This metric displays the number of pending outbound notification events.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

0

Not Defined

%value% Pending Outbound Notification Events

Data Source

This data is collected from the WF_DEFERRED queue.

User Action

If the READY message count is too high, then check if the Workflow Deferred or Deferred Notification Notifications Agent Listener are up and running and that the thread count is greater than or equal to 1.

Note:
You can increase the Notification Listener's thread count to improve message processing time.

15.3 Pending Outbound Notifications

This metric category provides information about the pending outbound notifications.

15.3.1 Pending Outbound Notifications

This metric displays the number of pending outbound notifications.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

0

Not Defined

%value% Pending Outbound Notifications

Data Source

This data is collected from the WF_DEFERRED queue.

15.4 Response

This metric category provides information about the status of the Oracle Workflow Notification Mailer target.

15.4.1 Status

This metric checks whether the status of the target is up or down.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

Alert Text

All Versions

Every 15 Minutes

Not Defined

0

%value% Workflow Notification Mailers Running

Data Source

This data is collected from the FND_SVC_COMPONENTS and FND_CONCURRENT_QUEUES.

User Action

Check if Workflow Mailer Container target is up.

16 Reports Server for Oracle Applications 11i

The Reports Server for Oracle Applications 11i monitors the Reports Server for Oracle Applications 11i.

- Load

- Response

- Sessions

16.1 Load

This metric category provides information about Reports Server usage.

16.1.1 Total CPU (%)

This metric displays the total percentage of CPU used by the Reports Server.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 15 Minutes

80

95

User Action

Find out the processes that are consuming the most CPU and take appropriate action.

16.1.2 Total Memory (%)

This metric displays the total percentage of memory used by the Reports Server.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 15 Minutes

10

20

User Action

Find out the processes that are consuming the most Memory and take appropriate action.

16.1.3 Total number of users

This metric displays the total number users of the Reports Server.

Target Version

Collection Frequency

All Versions

Every 15 Minutes

16.2 Response

This metric category provides information about the status of the Reports Server for Oracle Applications 11i target.

16.2.1 Status

This metric checks whether the target is up and running.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 5 Minutes

Not Defined

DOWN

User Action

If target is down, contact your administrator to restart the Reports Server.

16.3 Sessions

This category provides info about the Reports Server sessions.

16.3.1 Process Id

This metric displays the process ID of the Reports Server session.

16.3.2 Session CPU (%)

This metric displays the percentage of CPU used by the Reports Server session.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every15 Minutes

80

95

User Action

Find out the processes that are consuming the most CPU and take appropriate action.

16.3.3 Session Memory (%)

This metric displays the percentage of memory used by the Reports Server session.

Target Version

Collection Frequency

Default Warning Threshold

Default Critical Threshold

All Versions

Every 15 Minutes

10

20

User Action

Find out the processes that are consuming the most memory and take appropriate action.

A Retired Metrics

This appendix provides a list of the metric categories retired for this release.

A.1 Retired Metrics

Table A-1 provides a list of the retired metric categories and their replacements for the specified target types.

Table A-1 Retired Metrics

Target Type

Retired Metric Category

Replacement Metric Category

Oracle Concurrent Processing

Hourly Completed Requests

No. of Hourly Completed Requests by Status

Concurrent Requests by Status

No of Incomplete Requests by Status

Long Running Requests

Running Requests

Long Pending Requests

Pending Requests (Normal)

Pending Requests (Standby)

Long Running and Long Pending Requests

Running Requests

Pending Requests (Normal)

Pending Requests (Standby)

Custom Oracle Concurrent Manager

Pending Requests

Pending Requests (Normal)

Pending Requests (Standby)

Custom Oracle Concurrent Program

Hourly Completed Requests

No. of Hourly Completed Requests by Status

Concurrent Requests by Status

No. of Incomplete Requests by Status

Pending Requests

Pending Requests (Normal)

Pending Requests (Standby)

Long Running Requests

Running Requests

Long Pending Requests

Pending Requests (Normal)

Pending Requests (Standby)

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2016, Oracle and/or its affiliates. All rights reserved.

License Restrictions Warranty/Consequential Damages Disclaimer

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

Warranty Disclaimer

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

Restricted Rights Notice

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

Hazardous Applications Notice

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

Third-Party Content, Products, and Services Disclaimer

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Alpha and Beta Draft Documentation Notice

If this document is in preproduction status:

This documentation is in preproduction status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

Private Alpha and Beta Draft Documentation Notice

If this document is in private preproduction status:

The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your beta trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Master Agreement, Oracle License and Services Agreement, Oracle PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement which has been executed by you and Oracle and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.