Oracle Exalytics - Duplication Of TimesTen Optimizer Hints In TimesTen Database Connection Pool Object In OBI RPD (Doc ID 1530705.1)

Last updated on MARCH 20, 2015

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.0 to 11.1.1.6.12 [Release 11g]
Oracle Exalytics Software - Version 1.0.0.0.0 to 1.0.0.2.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

The following TimesTen optimizer hints are automatically duplicated, during the start up of the Oracle BI server, in the 'Execute on connect' section of TimesTen connection pools, as seen in the repository file (RPD) using the Oracle BI Administration Tool:

 call ttoptsetflag('rowlock',0)
 call ttoptsetflag('tbllock',1)
 call ttoptsetflag('mergejoin',0)
 call ttoptsetflag('nestedloop',1)

These are the built-in TimesTen procedures that tell the TimesTen query optimizer how to behave.  These procedures and options are documented in the TimesTen Database Reference Guide, here

Steps to reproduce the issue:

1) Create a TimesTen V11 database object, and corresponding connection pool, in an existing RPD.
2) Deploy the RPD, and start the Oracle BI server.
3) Make a small modification to the RPD in online mode. (e.g. rename a business model).
4) Check in the change, and save the RPD.
5) Review the 'Connection Scripts' tab, of the connection pool, to observe that the four TimesTen optimizer hint calls are added to the 'Execute on connect' section.
6) Restart the Oracle BI server.
7) Repeat Step (3).
8) Check in the changes, and save the RPD.
9) Notice that the following two calls are added, a second time, to the "Execute on connect" section of the connection pool, creating duplicate entries:
 call ttoptsetflag('mergejoin',0)
 call ttoptsetflag('nestedloop',1)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms