Performance Issue While Fetching Data From The Quality Plan Tables (Doc ID 2911451.1)

Last updated on DECEMBER 21, 2022

Applies to:

Goal

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.
 

Solution

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