Download IMDB Cache User's Guide

Monitoring cache groups and cache grids
TTGRID_cachestand_3B, 140.87.0.204, 5004 >
For more information about the ttGridNodeStatus built-in procedure, see
"ttGridNodeStatus" in Oracle TimesTen In-Memory Database Reference.
Suspending global AWT cache group operations
You can use the ttGridGlobalCGSuspend built-in procedure to temporarily block
these operations for global AWT cache groups:
■
Dynamic loading
■
Deleting cache instances
Use the ttGridGlobalCGResume built-in procedure to re-enable these operations.
Tracking DDL statements issued on cached Oracle tables
When a DDL statement is issued on a cached Oracle table, this statement can be
tracked in the Oracle TT_version_DDL_L table when the Oracle
TT_version_schema-ID_DDL_T trigger is fired to insert a row into the table, where
version is an internal TimesTen version number and schema-ID is the ID of user
that owns the cached Oracle table. A trigger is created for each Oracle user that owns
cached Oracle tables. One DDL tracking table is created to store DDL statements
issued on any cached Oracle table. The cache administration user owns the
TT_version_DDL_L table and the TT_version_schema-ID_DDL_T trigger.
To enable tracking of DDL statements issued on cached Oracle tables, call the
ttCacheDDLTrackingConfig built-in procedure as the cache manager user. By
default, DDL statements are not tracked.
For more information about the ttCacheDDLTrackingConfig built-in procedure,
see "ttCacheDDLTrackingConfig" in Oracle TimesTen In-Memory Database Reference.
Example 7–5 Enabling tracking of DDL statements issued on cached Oracle tables
% ttIsql "DSN=cachealone1;UID=cacheuser;PWD=timesten;OraclePWD=oracle"
Command> call ttCacheDDLTrackingConfig('enable');
The TT_version_DDL_L table and TT_version_schema-ID_DDL_T trigger are
automatically created if the cache administration user has been granted the set of
required privileges including RESOURCE and CREATE ANY TRIGGER. These Oracle
objects are created when you create a cache group after tracking of DDL statements
has been enabled.
If you manually created the Oracle objects used to manage the caching of Oracle data,
you need to run the ttIsql utility's cachesqlget command with the
ORACLE_DDL_TRACKING option and the INSTALL flag as the cache manager user.
This command should be run for each Oracle user that owns cached Oracle tables that
you want to track DDL statements on. Running this command generates a SQL*Plus
script used to create the TT_version_DDL_L table and
TT_version_schema-ID_DDL_T trigger in the Oracle database.
After generating the script, use SQL*Plus to run the script as the sys user.
7-8 Oracle In-Memory Database Cache User's Guide