Performance Issue While Fetching Data From The Quality Plan Tables
(Doc ID 2911451.1)
Last updated on DECEMBER 21, 2022
Applies to:Oracle Quality - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, SUPPORT
Performance issue while fetching data from the Quality Plan tables
We have created a custom Collection Plan with custom Collection Elements which contains the information of a Flow or Discrete Job and the Quality Audit information whether it passed or failed, the pass/fail dates etc.
We are displaying this information in an extract. But the performance is too slow for the query which is fetching quality plan data. We have tried multiple methods – using table, view to write the query but are still facing slowness. Since it is using standard quality tables qa_plans, qa_results and the columns which are storing data in tables are from character1 to character19 columns of table qa_results and therefore I am not able to hit any index and unable to create any new index.
Please suggest ways on how to improve the performance. Since we need this quality data for various purposes.
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