General Concurrency Control Monitor Management Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
fwg1557098454552.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢

These columns identify monitor activities for Teradata Database concurrency control.

Column Name Mode Description Data Type
MonAllocates count Number of monitors allocated. FLOAT
MonBlocks count Number of times entry into a monitor was blocked. For example, the number of requests - the number of blocks = immediate grants. FLOAT
MonEnters count Number of times entry into a monitor was requested. FLOAT
MonYields count Number of times a monitor yield was requested. FLOAT