ttCacheAutorefreshLogDefrag

The ttCacheAutorefreshLogDefrag built-in procedure compact the trigger log space for a cache autorefresh table.

Note:

This procedure does not support log-based cache groups.

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.

Related Views

This procedure has no related views.

Syntax

ttCacheAutorefreshLogDefrag ('action')

Parameters

ttCacheAutorefreshLogDefrag has the parameters:

Parameter Type Description

Parameter	Type	Description
`action`	`VARCHAR (50) NOT NULL`	Acceptable values are: `Compact` - Defragments only the trigger log space. `CompactAndReclaim` - Defragments the trigger log space and the transaction commit buffer (reclaim space). 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.

action

VARCHAR (50) NOT NULL

Acceptable values are:

Compact - Defragments only the trigger log space.

CompactAndReclaim - Defragments the trigger log space and the transaction commit buffer (reclaim space).

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.