Support Article
poor performance on drill down of a Summary View
SA-3577
Summary
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
Error Messages
No error message, just slow response.
Steps to Reproduce
Drill down on any summary view report.
Root Cause
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.
Resolution
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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.