Slow Performance On Group Assigned Tasks Node In Universal Work Queue
(Doc ID 1391912.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Universal Work Queue - Version 12.0.6 to 12.0.6 [Release 12]
Information in this document applies to any platform.
UWQ users experience performance issues when the following SQL query is executed after selecting the Group Assigned Tasks node:
select count(resource_id) from IEU_UWQ_TASK_GA_REF_V v where exists ( select m.resource_id from jtf_rs_group_members m where m.group_id = owner_id and nvl(delete_flag, 'N') = :delete_flag and m.resource_id = :resource_id);
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