Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

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

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.


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.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us