Oracle Business Intelligence Applications Version 7.9.6.x Performance Recommendations

Oracle Business Intelligence Applications Version 7.9.6.x Performance Recommendations [ID 870314.1]

--------------------------------------------------------------------------------

Modified 12-MAY-2011 Type BULLETIN Status PUBLISHED

In this Document
Purpose
Scope and Application
Oracle Business Intelligence Applications Version 7.9.6.x Performance Recommendations



--------------------------------------------------------------------------------



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

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

Scope and Application
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 enviornment 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.

Oracle Business Intelligence Applications Version 7.9.6.x Performance Recommendations
Oracle Business Intelligence (BI) Applications Version 7.9.6.x delivers a number of adapters to various business applications on Oracle database. 7.9.6.x version is certified with other major data warehousing platforms. Each Oracle BI Applications implementation requires very careful planning to ensure the best performance both during ETL and web queries or dashboard execution.


This article discusses performance topics for Oracle BI Applications 7.9.6 and higher using Informatica PowerCenter 8.6.x ETL platform. It is intended for Oracle BI Administrators, DBAs and Applications implementers. Customers are encouraged to engage Oracle Expert Services to review their configurations prior to implementing the recommendations to their BI Application environments.


Please review the attached document for more details.


Attachments



--------------------------------------------------------------------------------
7962 Performance Technote (629.08 KB)


Related



--------------------------------------------------------------------------------
Products
--------------------------------------------------------------------------------

•Middleware > Business Intelligence > Oracle Business Intelligence Applications > Business Intelligence Applications Consumer
Keywords
--------------------------------------------------------------------------------
BUSINESS INTELLIGENCE; INTELLIGENCE; PERFORMANCE TUNING; WAREHOUSES




Back to top

Copyright (c) 2007, 2010, Oracle. All rights reserved. Legal Notices and Terms of Use | Privacy Statement Rate this document
Article Rating Rate this document
Excellent
Good
Poor

Did this document help you?
Yes
No
Just browsing

How easy was it to find this document?
Very easy
Somewhat easy
Not easy
CommentsProvide feedback for this article. Please use 'Contact Us' for other feedback. Important Note: this feedback may be anonymously visible to other customers until processed by Oracle Support.


Cancel