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.

Related Views

This procedure has this related view.

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.