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
trackingStatus	TT_VARCHAR(10)	Specifies whether DDL statements issued on cached Oracle database tables are tracked. Valid values are: enable - Enables tracking. disable (default) - Disables tracking.

Result Set

ttCacheDDLTrackingConfig returns no results.

Examples

Command> CALL ttCacheDDLTrackingConfig('enable');

This procedure is available only for cache operations.