ttBlockInfo

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

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.

This procedure returns a row for the element from which it was called. To see information about other elements, query the SYS.GV$BLOCK_INFO system table.

Related Views

This procedure has these related views.

SYS.GV$BLOCK_INFO

SYS.V$BLOCK_INFO

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 database.
`FreeBlocks`	`TT_BIGINT NOT NULL`	Total number of free blocks in the database.
`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();
< 1537, 16, 236036720, 235991352 >
1 row found.