Thursday Jan 22, 2015

Oracle Business Intelligence Applications Version 11g Performance Recommendations

The following technical white paper (linked in the given KM note) was written by the OBIEE Performance Development team. It is intended for experienced Oracle BI Administrators, DBAs and Applications implementers:

 Oracle Business Intelligence Applications Version 11g Performance Recommendations (Doc ID 1963225.1)

It discusses performance topics for Oracle BI Applications 11g (11.1.1.7.1 and higher) using Oracle Data Integrator (ODI) 11g 11.1.1.7.1, and using Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.x., such as:

  • Hardware Recommendations for Implementing Oracle BI Applications
  • Application Server Sizing and Capacity Planning Source Environments
  • Recommendations for Better Performance Oracle Warehouse
  • Recommendations for Better Performance Oracle BI Applications Best
  • Practices for Oracle Exadata Oracle BI Applications High Availability

Most of the recommendations are generic for BI Applications 11g contents and its BI techstack.

The document covers advanced performance tuning techniques in ODI, OBIEE and Oracle RDBMS, so all recommendations must be carefully verified in a test environment before applied to a production instance.

Customers are encouraged to engage  Oracle Expert Services to review their configurations prior to implementing the recommendations to their BI Applications environments.

Monday Apr 22, 2013

new Oracle BI Apps (OBIA) performance recommendations released

(in via Lia)

We just got note that Development has released a new version of the OBIA 7.9.6.x performance recommendations document.

You can find this in the  KM note Oracle Business Intelligence Applications Version 7.9.6.x Performance Recommendations [870314.1]

Some of the key points (and really just some in this 134 page long guide):

  • Storage Considerations for Oracle Business Analytics Warehouse
  • Source Environments Recommendations for Better Performance
  • Oracle Warehouse Recommendations for Better Performance
  • Oracle BI Applications Best Practices for Oracle Exadata
  • OBIEE Queries Performance Recommendations
  • Oracle BI Applications High Availability

A word to the wise:
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.

You have been warned ;)

So - although it is available for anyone to read, we strongly advise that you only tweak your live system with this guide if you really, really know what you are doing - There is no magic button labelled "Click here for faster system" but a lot of things make sense and can assist in speeding up your OBIA system.

About


This blog talks about the latest news and upcoming events initiated by the EPM/BI Proactive Support Team.

Authors:

italia.nowodworska(€)oracle.com
torben.hein(€)oracle.com
paul.anderson(€)oracle.com
julie.foster(€)oracle.com





Search

Archives
« August 2015
SunMonTueWedThuFriSat
      
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
     
Today