Memory Columns | ResUsageSvpr Table | Teradata Vantage - Memory: Memory Resident 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 represent the amount of memory resident specific to virtual processor activities, subdivided into memory types. The columns do not include any memory allocations specific to the node the vproc is running under.

Disk memory segments can be in one of four states:
  • Clean (unmodified) and Unaccessed by any process (CU)
  • Dirty (modified) and Unaccessed (DU)
  • Clean and Accessed (CA)
  • Dirty and Accessed (DA)

Permanent segments for an entire table can be user-locked-in to memory. These are called frozen segments (Frz), and no state subdivision is necessary because they cannot be aged or forced out of memory.

Column Name Mode Description Data Type
MemAPtKBResCA track Current KB resident in memory for append table or permanent journal table data block or cylinder index disk segments that are currently clean and accessed.
This column is not currently valid. It should not be used.
FLOAT
MemAPtKBResCU track Current KB resident in memory for append table or permanent journal table data block or cylinder index disk segments that are currently clean and not accessed.
This column is not currently valid. It should not be used.
FLOAT
MemAPtKBResDA track Current KB resident in memory for append table or permanent journal table data block or cylinder index disk segments that are currently dirty and accessed.
This column is not currently valid. It should not be used.
FLOAT
MemAPtKBResDU track Current KB resident in memory for append table or permanent journal table data block or cylinder index disk segments that are currently dirty and unaccessed.
This column is not currently valid. It should not be used.
FLOAT
MemPCiKBResCA track Current KB resident in memory for permanent cylinder index disk segments that are currently clean and accessed.
This column is not currently valid. It should not be used.
FLOAT
MemPCiKBResCU track Current KB resident in memory for permanent cylinder index disk segments that are currently clean and not accessed.
This column is not currently valid. It should not be used.
FLOAT
MemPCiKBResDA track Current KB resident in memory for permanent cylinder index disk segments that are currently dirty and accessed.
This column is not currently valid. It should not be used.
FLOAT
MemPCiKBResDU track Current KB resident in memory for permanent cylinder index disk segments that are currently dirty and unaccessed.
This column is not currently valid. It should not be used.
FLOAT
MemPDbKBResCA track Current KB resident in memory for permanent data block segments that are currently clean and accessed.
This column is not currently valid. It should not be used.
FLOAT
MemPDbKBResCU track Current KB resident in memory for permanent data block disk segments that are currently clean and not accessed.
This column is not currently valid. It should not be used.
FLOAT
MemPDbKBResDA track Current KB resident in memory for permanent data block disk segments that are currently dirty and accessed.
This column is not currently valid. It should not be used.
FLOAT
MemPDbKBResDU track Current KB resident in memory for permanent data block disk segments that are currently dirty and unaccessed.
This column is not currently valid. It should not be used.
FLOAT
MemSCiKBResCA track Current KB resident in memory for regular or restartable spool cylinder index disk segments that are currently clean and accessed.
This column is not currently valid. It should not be used.
FLOAT
MemSCiKBResCU track Current KB resident in memory for regular or restartable spool cylinder index disk segments that are currently clean and not accessed.
This column is not currently valid. It should not be used.
FLOAT
MemSCiKBResDA track Current KB resident in memory for regular or restartable spool cylinder index disk segments that are currently dirty and accessed.
This column is not currently valid. It should not be used.
FLOAT
MemSCiKBResDU track Current KB resident in memory for regular or restartable spool cylinder index disk segments that are currently dirty and unaccessed.
This column is not currently valid. It should not be used.
FLOAT
MemSDbKBResCA track Current KB resident in memory for regular or restartable spool data block disk segments that are currently clean and accessed.
This column is not currently valid. It should not be used.
FLOAT
MemSDbKBResCU track Current KB resident in memory for regular or restartable spool data block disk segments that are currently clean and not accessed.
This column is not currently valid. It should not be used.
FLOAT
MemSDbKBResDA track Current KB resident in memory for regular or restartable spool data block disk segments that are currently dirty and accessed.
This column is not currently valid. It should not be used.
FLOAT
MemSDbKBResDU track Current KB resident in memory for regular or restartable spool data block disk segments that are currently dirty and unaccessed.
This column is not currently valid. It should not be used.
FLOAT
MemTJtKBResCA track Current KB resident in memory for transient journal table or WAL data block or WAL cylinder index disk segments that are currently clean and accessed.
This column is not currently valid. It should not be used.
FLOAT
MemTJtKBResCU track Current KB resident in memory for transient journal table or WAL data block or WAL cylinder index disk segments that are currently clean and not accessed.
This column is not currently valid. It should not be used.
FLOAT
MemTJtKBResDA track Current KB resident in memory for transient journal table or WAL data block or WAL cylinder index disk segments that are currently dirty and accessed.
This column is not currently valid. It should not be used.
FLOAT
MemTJtKBResDU track Current KB resident in memory for transient journal table or WAL data block or WAL cylinder index disk segments that are currently dirty and unaccessed.
This column is not currently valid. It should not be used.
FLOAT