ttBlockInfo

Description

This procedure provides information about perm blocks and the amount of block-level fragmentation in a data store.

Required privilege

This procedure requires no privilege.

Syntax

ttBlockInfo()

Parameters

ttBlockInfo has no parameters.

Result set

ttBlockInfo returns the result set:

Column	Type	Description
`TotalBlocks`	TT_BIGINT NOT NULL	Total number of blocks in the data store.
`FreeBlocks`	TT_BIGINT NOT NULL	Total number of free blocks in the data store.
`FreeBytes`	TT_BIGINT NOT NULL	Total size of the free blocks.
`LargestFree`	TT_BIGINT NOT NULL	Size of the largest free block.

Examples

CALL ttBlockInfo();
< 288, 3, 128711700, 128698596 >
1 row found.