ttCacheAutorefreshLogDefrag
The ttCacheAutorefreshLogDefrag
built-in procedure compact the trigger log space for a cache autorefresh table.
For usage details, see Defragmenting Change Log Tables in the Tablespace 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
ttCacheAutorefreshLogDefrag ('action')
Parameters
ttCacheAutorefreshLogDefrag
has the parameters:
Parameter | Type | Description |
---|---|---|
|
|
Acceptable values are:
Note: The reclaim phase takes a lock on the trigger log table for a brief moment. This can suspend the workload from writing into the base table. |
Result Set
ttCacheAutorefreshLogDefrag
returns no results.
Examples
In this example, the call compacts or defragments only the trigger log space.
Command> call ttCacheAutorefreshLogDefrag('CompactOnly');
This procedure is available only for cache operations.
See Also