WOS_CONTAINER_STORAGE

Monitors information about WOS storage, which is divided into regions. Each region allocates blocks of a specific size to store rows.

Note: The WOS allocator can use large amounts of virtual memory without assigning physical memory.

Column Name Data Type Description
NODE_NAME

VARCHAR

The node name for which information is listed.

WOS_TYPE

VARCHAR

Returns one of the following:

  • system – for system table queries
  • user – for other user queries
WOS_ALLOCATION_REGION

VARCHAR

The block size allocated by region in KB. The summary line sums the amount of memory used by all regions.

REGION_VIRTUAL_SIZE_KB

INTEGER

The amount of virtual memory in use by region in KB. Virtual size is greater than or equal to allocated size, which is greater than or equal to in-use size.

REGION_ALLOCATED_SIZE_KB

INTEGER

The amount of physical memory in use by a particular region in KB.

REGION_IN_USE_SIZE_KB

INTEGER

The actual amount of data stored by the region in KB. The amount of memory used by the WOS is typically capped at one quarter physical memory per node.

REGION_SMALL_RELEASE_COUNT

INTEGER

Internal use only

REGION_BIG_RELEASE_COUNT

INTEGER

Internal use only

EXTRA_RESERVED_BYTES

INTEGER

The amount of extra memory allocated to maintain WOS sort information.

EXTRA_USED_BYTES

INTEGER

The amount of memory in use currently to maintain the WOS sort information.