CONCURRENT_REQUESTS is very high and should be purged

Health Check Alert: The number of records in the table FND_CONCURRENT_REQUESTS is very high and should be purged to avoid performance issues

Health Check Alert: The number of records in the table FND_CONCURRENT_REQUESTS is very high and should be purged to avoid performance issues [ID 1095625.1]
Modified 04-JAN-2011 Type REFERENCE Status PUBLISHED
In this Document
Purpose
Scope
Health Check Alert: The number of records in the table FND_CONCURRENT_REQUESTS is very high and should be purged to avoid performance issues
Description
Risk
Recommendation
References
Applies to:

Oracle Application Object Library - Version: ALL
Information in this document applies to Any Platform,.
Health Check Category: Performance
Severity Level: Warning
Purpose

This document provides a quick reference explaining the following Health Check Alert:

The number of records in the table FND_CONCURRENT_REQUESTS is very high and should be purged to avoid performance issues
Scope

This document is intended for Database Administrators (DBA) / System Administrators / Application Managers.
Health Check Alert: The number of records in the table FND_CONCURRENT_REQUESTS is very high and should be purged to avoid performance issues

IMPORTANT

My Oracle Support provides a proactive health check that automatically detects and notifies you of the existence of this issue before it impacts your business. To leverage this proactive support capability, install the Oracle Configuration Manager (OCM). Information on installing the Oracle Configuration Manager can be found on the Collector tab of My Oracle Support. To view the full portfolio of health checks available, see Note 868955.1
Description

Checks the number of records in the table FND_CONCURRENT_REQUESTS for any performance issues at concurrent manager tier.

Risk

There are 500000+ records in the FND_CONCURRENT_REQUESTS table which can cause performance issues with the the concurrent processing sub-system. We recommended you purge the eligible records.

No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...