ttCacheAWTThresholdSet

Description

Indicates the threshold for the number of transaction log files that can accumulate before AWT is considered either dead or too far behind to catch up. This setting applies to all subscribers to the data store. When the threshold is exceeded, updates are no longer sent to Oracle. If no threshold is set then the default is zero.

Using this built-in procedure, the threshold can be set after an AWT cache group has been created.

This setting can be overwritten by a CREATE REPLICATION statement that resets the Log Failure Threshold for the data store.

Required privilege

This procedure requires the CACHE_MANAGER privilege.

Syntax

ttCacheAWTThresholdSet(threshold)

Parameters

ttCacheAWTThresholdSet has the parameter:

Parameter	Type	Description
`threshold`	TT_INTEGER	Specifies the number of transaction log files for all AWT cache groups associated with the data store. If the threshold is NULL, the log failure threshold is set to zero.

Result set

ttCacheAWTThresholdSet returns no results.

Example

To set the threshold to allow 12 transaction log files to accumulate, use:

CALL ttCacheAWTThresholdSet(12);

Note

This procedure is available for Oracle In-Memory Database Cache.

The user is responsible to recover when the threshold is exceeded.