My Oracle Support Banner

Query Performance In 12c (Doc ID 2357707.1)

Last updated on NOVEMBER 08, 2019

Applies to:

Oracle Process Manufacturing Systems - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, Other Issues

ACTUAL BEHAVIOR
---------------
Performance issue with SQL scripts after upgrade to R12.2.6

Upgrade is done for DB and Apps
EBS 12.0.6 & DB 11.1.0.7 to EBS 12.2.6 & DB 12.1.0.2

EXPECTED BEHAVIOR
-----------------------
Not to have a performance issue.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Running query in database there is a lack of response.

Select Distinct description
From GME_Batch_Step_Resources R,
FND_Lookup_Values L
Where 1=1
and R.Batch_id=593137
and L.Meaning = R.Resources
and L.Lookup_type='MDN_Resource_cc_IDENT_Wip_LK'
and L.Enable_Flag=Y
and Trunc(sysdate) between Trunc (
NVL(L.Start_date_active, sysdate-1))
and trunc(
NVL(L.END_DATE_Active,sysdate +1))
and L.Language='us'

 

 

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
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.