Accenture Enkitec Group E4 Webinar

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.  As the posts become available links will be updated in this post.
  • Introduction
  • nVision Performance Options
  • Effects of Performance Options
  • Indexing of Ledger, Budget and Summary Ledger Tables
  • Partitioning of Ledger, Budget and Summary Ledger Tables
  • Additional Oracle Instrumentation for nVision
  • Logging Selector Usage
  • Analysis of Tree Usage  with the Selector Log
  • Interval Partitioning and Statistics Maintenance of Selector Tables
  • Compression without the Advanced Compression option
  • Maintaining Statistics on Non-Partitioned Selector Tables
  • Excel -v- OpenXML
The current versions of scripts mentioned in the series will be made available on GitHub.


1 comment :

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 12.1.0.2 database. The report runs fine in our prod environment where optimizer_features_enable='10.2.0.4'. 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.