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.
Required Privilege
This procedure requires no privileges.
Usage in TimesTen Scaleout and TimesTen Classic
This procedure is supported in TimesTen Classic but not supported in TimesTen Scaleout.Related Views
This procedure has no related views.
Syntax
ttCacheAllowFlushAwtSet (enableFlush)
Parameters
ttCacheAllowFlushAwtSet
has the parameters:
Parameter | Type | Description |
---|---|---|
|
|
|
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
- When There Is Unsynchronized Data in the Cache Groups section in the Oracle TimesTen In-Memory Database Replication Guide.