Tuesday, October 10, 2017

nVision Performance Tuning: Table of Contents

This post is an index for a series of blog posts that discuss how to get good performance from nVision as used in General Ledger reporting.
The current versions of scripts mentioned in the series are available on GitHub.


Maggie K. said...

Thank you for such a timely series. I am trying to resolve an ORA-04036 PGA memory used by instance exceeds PGA_AGGREGATE_LIMIT errors on a user nvision report in our Oracle database. The report runs fine in our prod environment where optimizer_features_enable=''. I have tried many different combinations of performance options for the trees in the layout to no avail. I am looking forward to more posts on this topic.

Navneet Upneja said...

You need to set PGA_AGGREGATE_LIMIT to 0. Parameter has default value like 2G and if any session hits the limit, gets terminated. This was introduced in 12c and need to be set to 0, for it to behave normally.