1. Cache Guide
  2. Methods for Transmitting Changes Between TimesTen and Oracle Databases
  3. Dynamic Cache Groups
  4. Enabling or Disabling Dynamic Load

Enabling or Disabling Dynamic Load

You can enable or disable dynamic load with the DynamicLoadEnable connection attribute.

  • 0 - Disables dynamic load of Oracle Database data to a single dynamic cache group for the current connection.

  • 1 (default) - Enables dynamic load of Oracle Database data to a single dynamic cache group per statement for the current connection.

You can set the DynamicLoadEnable optimizer hint to temporarily enable or disable dynamic loading of a single cache instance for a particular transaction. You can set the DynamicLoadEnable optimizer hint with one of the following methods:

  • Use the ttIsql utility set dynamicloadenable command.

  • Call the ttOptSetFlag built-in procedure with the DynamicLoadEnable flag set to the desired value. The following example sets dynamic loading to 1. 

    call ttOptSetFlag('DynamicLoadEnable', 1)

Note:

See DynamicLoadEnable, ttIsql or ttOptSetFlag in the Oracle TimesTen In-Memory Database Reference.

You can also set connection attributes with the SQLSetConnectOption ODBC function (ODBC 2.5) or the SQLSetConnectAttr function (ODBC 3.5). See the Option Support for ODBC 2.5 SQLSetConnectOption and SQLGetConnectOption and Attribute Support for ODBC 3.5 SQLSetConnectAttr and SQLGetConnectAttr sections in the Oracle TimesTen In-Memory Database C Developer's Guide.