My Oracle Support Banner

Performance Issue Running 'DQM Identification Program' Due to Full Table Scan on Tables CS_INCIDENTS_AUDIT_B And CS_INCIDENTS_All_B (Doc ID 2291960.1)

Last updated on MARCH 04, 2019

Applies to:

Oracle Teleservice - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, In Production Instance

ACTUAL BEHAVIOR
---------------
While running the concurrent program 'DQM Identification program'. with Parameter for persons, observed from AWR report that the table CS_INCIDENTS_AUDIT_B table utilized more execution time.
The following query takes 28.28% of total activity.

* Query:
    SELECT INCIDENT_AUDIT_ID FROM CS_INCIDENTS_AUDIT_B WHERE SITE_ID =:p_from_id


EXPECTED BEHAVIOR
-----------------------
Expect the select query to complete in few seconds so that the performance of the concurrent program 'DQM Identification program' improves

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to the application
2. Run the concurrent program 'DQM Identification program' with Persons parameter

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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