nVision GL Reporting Performance Tuning on Oracle RDBMS will look at the techniques and options available in both PeopleSoft and the Oracle database that can be used to get nVision to perform well as a General Ledger reporting tool. We will look at indexing of the ledger and summary ledger tables, choice of tree selector performance issues, use of partitioning for both the ledger and tree selector tables, management of statistics, compression, clustering, materialized views and query rewrite. We will also look at why different choices are required on Engineered and non-Engineered systems.
UKOUG Applications Conference 2018
nVision GL Reporting Performance Tuning on Oracle RDBMS will look at the techniques and options available in both PeopleSoft and the Oracle database that can be used to get nVision to perform well as a General Ledger reporting tool. We will look at indexing of the ledger and summary ledger tables, choice of tree selector performance issues, use of partitioning for both the ledger and tree selector tables, management of statistics, compression, clustering, materialized views and query rewrite. We will also look at why different choices are required on Engineered and non-Engineered systems.
Subscribe to:
Posts
(
Atom
)
Posts
No comments :
Post a Comment