Memory Columns | ResUsageSvpr Table | Teradata Vantage - 17.05 - Memory: Memory Resident 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

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