OBIEE 11.1.1 - Disable Wrap Data Types in WebLogic Server 10.3.x

Posted by Ahmed Awan on Oracle Blogs See other posts from Oracle Blogs or by Ahmed Awan
Published on Thu, 17 Nov 2011 10:11:46 -0600 Indexed on 2011/11/18 1:56 UTC
Read the original article Hit count: 876

By default, JDBC data type’s objects are wrapped with a WebLogic wrapper. This allows for features like debugging output and track connection usage to be done by the server. The wrapping can be turned off by setting this value to false. This improves performance, in some cases significantly, and allows for the application to use the native driver objects directly.

Tip: How to Disable Wrapping in WLS Administration Console

You can use the Administration Console to disable data type wrapping for following JDBC data sources in bifoundation_domain domain:

Data Source Name

bip_datasource

mds-owsm

EPMSystemRegistry

 

To disable wrapping for each JDBC data source (as stated in above table):

1.     If you have not already done so, in the Change Center of the Administration Console, click Lock & Edit.

2.     In the Domain Structure tree, expand Services, then select Data Sources.

3.     On the Summary of Data Sources page, click the data source name for examplemds-owsm”.

4.     Select the Configuration: Connection Pool tab.

5.     Scroll down and click Advanced to show the advanced connection pool options.

6.     In Wrap Data Types, deselect the checkbox to disable wrapping.

7.     Click Save.

8.     To activate these changes, in the Change Center of the Administration Console, click Activate Changes.

Important Note: This change does not take effect immediately—it requires the server be restarted.


© Oracle Blogs or respective owner

Related posts about /OBIEE/Performance Tuning