ttCacheAllowFlushAwtSet

The ttCacheAllowFlushAwtSet built-in procedure enables you to run a FLUSH CACHE GROUP statement against an AWT cache group.

This procedure should only be used in a specific recovery scenario, as described in When There Is Unsynchronized Data in the Cache Groups section in the Oracle TimesTen In-Memory Database Replication Guide.

Set auto commit to off before running the ttCacheAllowFlushAwtSet built-in procedure when setting the enableFlush parameter to 1; otherwise, this parameter automatically resets to 0 directly after running the built-in procedure. Then, perform a commit after you run the FLUSH CACHE GROUP statement and run the ttCacheAllowFlushAwtSet built-in procedure to reset the enableFlush parameter back to 0.

Note:

This procedure does not support log-based cache groups.

Required Privilege

This procedure requires no privileges.

Related Views

This procedure has no related views.

Syntax

ttCacheAllowFlushAwtSet (enableFlush)

Parameters

ttCacheAllowFlushAwtSet has the parameters:

Parameter Type Description

allow

TT_INTEGER NOT NULL

0 - The user is prevented from running a FLUSH CACHE GROUP statement against an AWT cache group, which is the intended restriction.

1 - The user is allowed to run a FLUSH CACHE GROUP statement against an AWT cache group, which should only be done for recovery, as described in When There Is Unsynchronized Data in the Cache Groups section in the Oracle TimesTen In-Memory Database Replication Guide.

Result Set

ttCacheAllowFlushAwtSet returns no results.

Examples

The following example shows how to run the ttCacheAllowFlushAwtSet built-in procedure to first allow and then disallow a FLUSH CACHE GROUP statement to be run against the marketbasket AWT cache group. 

Command> set autocommit off;
         CALL ttCacheAllowFlushAwtSet(1);
         FLUSH CACHE GROUP marketbasket;
         CALL ttCacheAllowFlushAwtSet(0);
         COMMIT;

See Also