I wrote a series of blogs that discusses how to tune the PeopleSoft nVision reporting tool when it is used for General Ledger Reporting. They reference a collection of utility scripts that are available on Github at https://github.com/davidkurtz/nVision.
Including:
- Additional instrumentation through fine-grained auditing
- Monitoring tree using in selector tables
- Interval partitioning tree selectors
- Setting statistics on tree selector tables