How to run ASCP Performance Analyzer Tool as a Concurrent Request (Doc ID 1556409.1)

Last updated on OCTOBER 20, 2019

Applies to:

Goal

This is an Addendum to Note 1554183.1 - ASCP Performance Analyzer script for E-Business Suite ASCP Monitoring and Maintenance. This Document will guide the user through the steps to register and configure the Oracle ASCP Performance Analyzer Tool (named ascp_perf_analyzer.sql) to be executed as a standard Concurrent Request from Oracle Applications.

Currently, manual execution of the existing script (ascp_perf_analyzer.sql) requires a System Administrator or DBA user with access to SQL*Plus and Applications Owner (APPS) password. The creation of this Concurrent Request needs to be performed by a System Administrator; however, this will be a one time task. Once installed, end users with the proper Responsibility will have the ability to execute the ASCP Performance Analyzer Tool as a single request, or schedule periodically without the need of SQL access or the Applications Owner (APPS) password.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.