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.

Related Views

This procedure has this related view.

SYS.V$HEAP_INFO

Syntax

ttHeapInfo('name')

Parameters

ttHeapInfo has the parameter:

Parameter Type Description

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.

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