My Oracle Support Banner

Oracle Business Intelligence Applications Version 7.9.6.x Performance Recommendations (Doc ID 870314.1)

Last updated on APRIL 17, 2023

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6 [1340] to [Release V7]
Information in this document applies to any platform.


This article discusses performance topics for Oracle Business Intelligence Applications version 7.9.6.x.


The information contained in this bulletin is applicable to Oracle Business Intelligence Applications version 7.9.6.x and is intended for Oracle Business Intelligence Administrators, DBAs and Applications implementers. It covers advanced performance tuning techniques in Informatica and Oracle RDMS, so all recommendations must be carefully verified in a test environment before applying to a production instance.

Please note similar detailed performance recommendation for Teradata are expected in next 12 months. For other databases like DB2, SQL Server detailed performance recommendation will be published in future but no timeframe is available. Also please note General /Key Performance Guideliness/Parameters for Teradata, DB2 and SQL-Server are included in Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.