ttCacheDDLTrackingConfig
This procedure enables or disables tracking of DDL statements issued on cached Oracle database tables. By default, DDL statements are not tracked.
DDL tracking saves the change history for all the cached Oracle database tables. One DDL tracking table is created to store DDL statements issued on any cached Oracle database table. You can use this information to diagnose autorefresh problems.
See Tracking DDL Statements Issued on Cached Oracle Database Tables in Oracle TimesTen In-Memory Database Cache Guide.
Required Privilege
This procedure requires the CACHE_MANAGER
privilege.
Usage in TimesTen Scaleout and TimesTen Classic
This procedure is supported in both TimesTen Classic and TimesTen Scaleout.Related Views
This procedure has no related views.
Syntax
ttCacheDDLTrackingConfig('trackingStatus')
Parameters
ttCacheDDLTrackingConfig
has the parameter:
Parameter | Type | Description |
---|---|---|
|
|
Specifies whether DDL statements issued on cached Oracle database tables are tracked. Valid values are:
|
Result Set
ttCacheDDLTrackingConfig
returns no results.
Examples
Command> CALL ttCacheDDLTrackingConfig('enable');
This procedure is available only for cache operations.