Connection Pools


Connection Pools – What it is and Best Practices 

The Connection pool is an object in the Physical layer that describes access to the data source. It contains information about the connection between the Oracle BI Server and that data source.

The Physical layer in the Administration Tool contains at least one connection pool for each database. When you create the Physical layer by importing a schema for a data source, the connection pool is created automatically. You can configure multiple connection pools for a database.
Connection pools allow multiple concurrent data source requests (queries) to share a single database connection, reducing the overhead of connecting to a database. For each connection pool, you must specify the maximum number of concurrent connections allowed. After this limit is reached, the connection request waits until a connection becomes available. Increasing the allowed number of concurrent connections can potentially increase the load on the underlying database accessed by the connection pool.

Improperly defined connection pool would affect the OBIEE performance and user experience. Here are some tips 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

Log Files paths in OBIEE 11g ..Imp to know !!


Log files store all important information required to troubleshoot issues. Best way in OBIEE 11g, is to get them from Enterprise Manager Console.But we can still see these files in OBIEE install directory.
  • Enterprise Manager Console
Log on to EM Console (http://localhost:7001/em) . Once you logged on, in the left pane navigate to Farm_bifoundation_domain –> Business Intelligence–>coreapplications–>Diagnostics–>Log Messages
Here you can see the Most Recent Errors and Most Recent Warnings.
Available files:
• Presentation Services Log
• Server Log
• Scheduler Log
• Cluster Controller Log and many more
  • Log files in OBIEE Install directory
We can find all log files for OBIEE Components in OBIEE install directory under OBIEE_HOME/instances/instance1/diagnostics/logs 
These are the different type of log files:
Presentation Server log files
/instances/instance1/diagnostics/logs/OracleBIPresentationServicesComponent/coreapplication_obips1

BI Server log files
/instances/instance1/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1

Scheduler log
/instances/instance1/diagnostics/logsOracleBISchedulerComponent/coreapplication_obisch1

Cluster Controller log
/instances/instance1/diagnostics/logs/OracleBIClusterControllerComponent\coreapplication_obiccs1

ODBC log
/instances/instance1/diagnostics/logs/OracleBIODBCComponent/coreapplication_obips1


OPMN log
/instances/instance1/diagnostics/logs/OPMN/opmn

Web logic Server Log Locations: You can also find out server related logs at below locations:

BI Managed Server:

OBIEE_HOME\user_projects\domains\bifoundation_domain\servers\bi_server1\logs

Admin Server:

OBIEE_HOME\user_projects\domains\bifoundation_domain\servers\AdminServer\logs

=============================================================
Other Important file paths:

Catalog Path

Drive:\Oracle\Middleware\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog

Repository Path

D:\Oracle\Middleware\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository

Instanceconfig.xml —-> file path

D:\Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

NQSConfig.INI file path :

D:\Oracle\Middleware\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1