Performance Issue When Opening the UWQ - Query is Executed Millions of Times
Last updated on JUNE 04, 2018
Applies to:Oracle Advanced Collections - Version 12.1.3 and later
Information in this document applies to any platform.
When opening the Delinquent Accounts node of the UWQ, it takes 10+ minutes to open for roughly 300 records.
The details from the AWR report show that a specific query is executed 9 million times:
SQL ordered by Gets (Global)
select count(resource_id) from...10,174,766
SELECT 'Y' FROM MO_GLOB_ORG_AC...9,702,280
The tkrprof trace also shows the same query being executed millions of times:
MO_GLOB_ORG_ACCESS_TMP WHERE ORGANIZATION_ID = :B1
Steps to Reproduce:
Responsibility: Collections Agent
Navigation: Collectors Work Queue
- Click on the Delinquent Accounts node.
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