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
utilityset dynamicloadenable
command. -
Call the
ttOptSetFlag
built-in procedure with theDynamicLoadEnable
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.