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 JULY 30, 2017

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:
Sql id - b3p2pxqkb1z2z
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



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms