17.05 - MDL Segment Columns - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K
Column Name Mode Description Data Type
SegMDLAlloc[00-10] count Number of segments (between 64 KB for SegMDLAlloc00 and 64 MB for SegMDLAlloc10) allocated for the MDL pool during this period. FLOAT
SegMDLFree[00-10] count Number of dirty segments (between 64 KB for SegMDLFree00 and 64 MB for SegMDLFree10) freed from the MDL pool during this period. FLOAT
SegMDLRelease[00-10] count Number of clean segments (between 64 KB for SegMDLRelease00 and 64 MB for SegMDLRelease10) freed from the MDL pool during this period. FLOAT
SegMDLRecycle[00-10] count Number of segments (between 64 KB for SegMDLRecycle00 and 64 MB for SegMDLRecycle10) recycled to the MDL pool during this period. FLOAT