My Oracle Support Banner

Performance Issue When Opening the UWQ - Query is Executed Millions of Times (Doc ID 2407240.1)

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.

Symptoms

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:

SELECT 'Y'
FROM
MO_GLOB_ORG_ACCESS_TMP WHERE ORGANIZATION_ID = :B1


Steps to Reproduce:

Responsibility: Collections Agent
Navigation
: Collectors Work Queue

  1. Click on the Delinquent Accounts node.

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!


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