Kumar Kambam’s OBIEE Blog

Intelligence on Oracle Business Intelligence

Connection Pools – Best Practices

Most of the times not much thought is given to defining connection pools while developing rpd. Improperly defined connection pool would affect the OBIEE performance and user experience. Here are some of the things to consider while defining connection pool.

  • Change the default maximum connections. The default is 10. Based on your system usage change the value that is more realistic to your system usage
  • Create a separate connection pool for execution of session variables
  • Create a separate connection pool for the execution of aggregate persistence wizard. Remember that you need to give the schema user owner credentials for this connection pool as the wizard creates and drops tables
  • If need be create a separate connection pool for VVIPs. You can control who gets to use the connection pool based on the connection pool permissions.
Advertisements

August 17, 2009 - Posted by | Best Practices, OBIEE, OBIEE Performance Tuning

2 Comments »

  1. Hi Kumar,

    Thanks a lot of the information on the blog.keep up the good work.

    I have a question, Is it possible to import the tables from two diff data bases.

    For eg: If i want to import the data from Oracle and another from Tera data. Is it possible to work arround this kind of scenario.

    Thanks In Advance.

    Srinath

    Comment by Srinath | December 21, 2009

  2. Yes, you can import tables from two different kinds of databases. They will have their own connection pool.

    Comment by Kumar Kambam | March 5, 2010


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: