ttCompact
This procedure compacts both the permanent and temporary data partitions of the database.
ttCompact
merges adjacent blocks of free space, but does not move any items that are allocated. Therefore, fragmentation that is caused by small unallocated blocks of memory surrounded by allocated blocks of memory is not eliminated by using ttCompact
.
Required Privilege
This procedure requires the ADMIN
privilege.
Usage in TimesTen Scaleout and TimesTen Classic
This procedure is supported in TimesTen Classic.
TimesTen Scaleout applications can call this built-in procedure.
In TimesTen Scaleout, this procedure runs on all elements in the grid.
Related Views
This procedure has no related views.
Syntax
ttCompact()
Parameters
ttCompact
has no parameters.
Result Set
ttCompact
returns no results.
Examples
CALL ttCompact ();
Notes
Compacting data does not modify result addresses.