poor performance on drill down of a Summary View
Poor performance on the drilldown of Summary View. The below query takes long time to execute.
SELECT pzPVStream as "pzPVStream" FROM pr4_fieldvalue where (pxInsId like ?) AND (pyRuleAvailable not like ?) and (pxObjClass = ?) order by pzInsKey
No error message, just slow response.
Steps to Reproduce
Drill down on any summary view report.
The root cause of this problem is defect/misconfiguration in the PRPC operating environment. The value of the Oracle database setting 'filesystemio_options' was changed from "NONE" to "SETALL", in an attempt to improve the database performance. This caused the above query to run slowly and trigger a large number of PEGA0005 alerts.
This issue is resolved by making the following change to the PRPC operating environment:
The value of the Oracle database setting 'filesystemio_options' was changed from "SETALL" to "NONE"
Published January 31, 2016 - Updated October 8, 2020
Was this useful?
0% found this useful
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.