17.00 - Memory: Task Context Segment Usage Columns - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

These columns identify the usage of task context segments and how they leave memory.

Column Name Mode Description Data Type
MemCtxtAccesses count Number of segments accessed. FLOAT
MemCtxtAccessKB count KB of segments accessed. FLOAT
MemCtxtDeaccesses count Number of segments deaccessed.

Deaccessed segments remain in memory until paged out through aging.

FLOAT
MemCtxtDeaccessKB count KB of segments deaccessed. FLOAT
MemCtxtDestroyKB count KB of segments destroyed. FLOAT
MemCtxtDestroys count Number of segments destroyed.

Destroyed segments are immediately dropped from memory.

FLOAT