ttHeapInfo

This procedure reports heap memory usage in the database. For each heap in the database, it displays the allocated size, size in use, high water mark (the maximum amount of size in use) and the number of deferred free buffers.

Required Privilege

This procedure requires no 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 locally on the element from which it is called.

Related Views

This procedure has these related views.

SYS.GV$HEAP_INFO

SYS.V$HEAP_INFO

Syntax

ttHeapInfo('name')

Parameters

ttHeapInfo has the parameter:

Parameter	Type	Description
name	TT_CHAR (30)	Name of the heap for which you would like information. If not specified, ttHeapInfo lists the names of all the heaps and their metrics.

Result Set

ttHeapInfo returns the result:

Column	Type	Description
name	TT_CHAR (30) NOT NULL	Name of the heap for which the heap memory info is being returned.
size	TT_BIGINT NOT NULL	The allocated sizes of the heap memory.
inUse	TT_BIGINT NOT NULL	The amount of heap memory in use.
highWater	TT_BIGINT NOT NULL	The maximum amount of heap memory used.
freeDeferred	TT_BIGINT NOT NULL	The number of deferred freed heap memory buffers.

Examples

CALL ttHeapInfo ('sampledb1');
< PERMANENT_0, 2515656, 2404112, 2582856, 0>
< PERMANENT_1, 1024, 1024, 1024, 0>
...
< INDEX_SNAPSHOT_VALUE_CONFIG_I, 2048, 776, 776, 0>
156 rows found