Skip Headers
Oracle® TimesTen In-Memory Database Reference
Release 11.2.1

Part Number E13069-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

Hide Navigation

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.