resusagesvprV | VantageCloud Lake - resusagesvprV - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Database: td_metric_svc

If you need detailed statistics for each virtual processor (vproc) in the system, use this view to:

  • Determine how each AMP is using memory.
  • Confirm that all parsing engines (PE) are being allocated work appropriately.
  • Compare physical IO reads and writes per AMP.
View Column Data Type Format Comment
Location VARCHAR(2048) UNICODE CASESPECIFIC X(2048) File path in object storage for metric data objects.
path_component_id VARCHAR(8000) UNICODE CASESPECIFIC X(8000) Operational group (primary cluster or compute cluster) ID.
path_collecttimestamp VARCHAR(8000) UNICODE CASESPECIFIC X(8000) Timestamp, in EPOCH timestamp format, this metric data was collected from your database and written to object storage.
path_year VARCHAR(8000) UNICODE CASESPECIFIC X(8000) The year in which the data was logged.
path_month VARCHAR(8000) UNICODE CASESPECIFIC X(8000) The month in which the data was recorded in the table.
path_day VARCHAR(8000) UNICODE CASESPECIFIC X(8000) The date on which the data was recorded in the table.
path_hour VARCHAR(8000) UNICODE CASESPECIFIC X(8000) The hour at which the data was recorded in the table.
path_minute VARCHAR(8000) UNICODE CASESPECIFIC X(8000) The minute at which the data was recorded in the table.
path_ver VARCHAR(8000) UNICODE CASESPECIFIC X(8000) The version of Vantage software that was running on the operational group.
TheDate DATE NOT NULL YYYY/MM/DD Local Date of the log entry.
NodeID INTEGER NOT NULL ZZZ9-9999 Numeric value that uniquely identifies a node (cloud compute instance) within a compute cluster. For example, '10001','10002'.
TheTime FLOAT NOT NULL 99:99:99.99 Nominal local time of the log entry.
GmtTime FLOAT NOT NULL 99:99:99.99 Nominal GMT time of the log entry. Greenwich Mean Time is not affected by the Daylight Saving Time adjustments that occur twice a year.
CabinetID
Not applicable. Do not use.
     Not applicable.
ModuleID
Not applicable. Do not use.
     Not applicable.
NodeType CHAR(8) LATIN NOT CASESPECIFIC NOT NULL X(8) Indicates the node (cloud compute instance) family. For example, '67_R5'.
TheTimestamp BIGINT NOT NULL -(20)9 Number of seconds since midnight, January 1, 1970.
CentiSecs INTEGER NOT NULL -(11)9 Actual number of centiseconds in the logging period.
Secs SMALLINT NOT NULL -(6)9 Actual number of seconds in the logging period.
NominalSecs SMALLINT NOT NULL -(6)9 Nominal number of seconds in the logging period.
SummaryFlag CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) Summarization status of this row. Possible values are N if the row is a non-summary row, and S if the row is a summary row.
ReservedS0 CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) Reserved for future use.
PM_COD_CPU SMALLINT NOT NULL -(6)9 Platform Metering CPU COD value in one tenths of a percent. For example, a value of 500 represents a COD value of 50.0%.
WM_COD_CPU SMALLINT NOT NULL -(6)9 Workload Management CPU COD value in one tenths of a percent. For example, a value of 500 represents a COD value of 50.0%.
Reserved00 SMALLINT NOT NULL -(6)9 Reserved for future use.
NCPUs SMALLINT NOT NULL -(6)9 Number of online CPUs on this node.
vprid INTEGER NOT NULL -(11)9 Identifies the vproc number (non-Summary Mode) or the vproc type (Summary Mode; 0 = NODE, 1 = AMP, 2 = PE, 3=GTW, 4=RSG, 5=TVS).
VprType CHAR(4) LATIN NOT CASESPECIFIC NOT NULL X(4) Type of vproc. The values can be NODE, AMP, PE, GTW, RSG, or TVS.
ReservedS1 CHAR(4) LATIN NOT CASESPECIFIC NOT NULL X(4) Reserved for future use.
MemPDbKBResCU FLOAT NOT NULL -(20)9 Current KB resident in memory for permanent data block disk segments that are clean and not accessed.
MemPCiKBResCU FLOAT NOT NULL -(20)9 Current KB resident in memory for permanent cylinder index disk segments that are clean and not accessed
MemSDbKBResCU FLOAT NOT NULL -(20)9 Current KB resident in memory for regular or restartable spool data block disk segments that are clean and not accessed.
MemSCiKBResCU FLOAT NOT NULL -(20)9 Current KB resident in memory for regular or restartable spool cylinder index disk segments that are clean and not accessed.
MemTJtKBResCU FLOAT NOT NULL -(20)9 Current KB resident in memory for transient journal table or WAL data block or WAL cylinder index disk segments that are clean and not accessed.
MemAPtKBResCU FLOAT NOT NULL -(20)9 Current KB resident in memory for append table or permanent journal table data block or cylinder index disk segments that are clean and not accessed.
MemPDbKBResDU FLOAT NOT NULL -(20)9 Current KB resident in memory for permanent data block disk segments that are dirty and unaccessed.
MemPCiKBResDU FLOAT NOT NULL -(20)9 Current KB resident in memory for permanent cylinder index disk segments that are dirty and unaccessed.
MemSDbKBResDU FLOAT NOT NULL -(20)9 Current KB resident in memory for regular or restartable spool data block disk segments that are dirty and unaccessed.
MemSCiKBResDU FLOAT NOT NULL -(20)9 Current KB resident in memory for regular or restartable spool cylinder index disk segments that are dirty and unaccessed.
MemTJtKBResDU FLOAT NOT NULL -(20)9 Current KB resident in memory for transient journal table or WAL data block or WAL cylinder index disk segments that are dirty and unaccessed.
MemAPtKBResDU FLOAT NOT NULL -(20)9 Current KB resident in memory for append table or permanent journal table data block or cylinder index disk segments that are dirty and unaccessed.
MemPDbKBResCA FLOAT NOT NULL -(20)9 Current KB resident in memory for permanent data block segments that are clean and accessed.
MemPCiKBResCA FLOAT NOT NULL -(20)9 Current KB resident in memory for permanent cylinder index disk segments that are clean and accessed.
MemSDbKBResCA FLOAT NOT NULL -(20)9 Current KB resident in memory for regular or restartable spool data block disk segments that are clean and accessed.
MemSCiKBResCA FLOAT NOT NULL -(20)9 Current KB resident in memory for regular or restartable spool cylinder index disk segments that are clean and accessed.
MemTJtKBResCA FLOAT NOT NULL -(20)9 Current KB resident in memory for transient journal table or WAL data block or WAL cylinder index disk segments that are clean and accessed.
MemAPtKBResCA FLOAT NOT NULL -(20)9 Current KB resident in memory for append table or permanent journal table data block or cylinder index disk segments that are clean and accessed.
MemPDbKBResDA FLOAT NOT NULL -(20)9 Current KB resident in memory for permanent data block disk segments that are dirty and accessed.
MemPCiKBResDA FLOAT NOT NULL -(20)9 Current KB resident in memory for permanent cylinder index disk segments that are dirty and accessed.
MemSDbKBResDA FLOAT NOT NULL -(20)9 Current KB resident in memory for regular or restartable spool data block disk segments that are dirty and accessed.
MemSCiKBResDA FLOAT NOT NULL -(20)9 Current KB resident in memory for regular or restartable spool cylinder index disk segments that are dirty and accessed.
MemTJtKBResDA FLOAT NOT NULL -(20)9 Current KB resident in memory for transient journal table or WAL data block or WAL cylinder index disk segments that are dirty and accessed.
MemAPtKBResDA FLOAT NOT NULL -(20)9 Current KB resident in memory for append table or permanent journal table data block or cylinder index disk segments that are dirty and accessed.
MemCtxtAccessKB FLOAT NOT NULL -(20)9 KB of segments accessed.
MemCtxtDeaccessKB FLOAT NOT NULL -(20)9 KB of segments deaccessed.
MemCtxtDestroyKB FLOAT NOT NULL -(20)9 KB of segments destroyed.
NetPtPReadKB FLOAT NOT NULL -(20)9 KB of point-to-point messages input to the vproc.
NetPtPWriteKB FLOAT NOT NULL -(20)9 KB of point-to-point messages output from the vproc.
NetBrdReadKB FLOAT NOT NULL -(20)9 KB of broadcast messages input to the vproc.
NetBrdWriteKB FLOAT NOT NULL -(20)9 KB of broadcast messages output from the vproc.
FilePDbAcqKB FLOAT NOT NULL -(20)9 KB logically acquired by FilePDbAcqs.
FilePCiAcqKB FLOAT NOT NULL -(20)9 KB logically acquired by FilePCiAcqs.
FileSDbAcqKB FLOAT NOT NULL -(20)9 KB logically acquired by FileSDbAcqs.
FileSCiAcqKB FLOAT NOT NULL -(20)9 KB logically acquired by FileSCiAcqs.
FileTJtAcqKB FLOAT NOT NULL -(20)9 KB logically acquired by FileTJtAcqs.
FileAPtAcqKB FLOAT NOT NULL -(20)9 KB logically acquired by FileAPtAcqs.
FilePDbAcqOtherKB FLOAT NOT NULL -(20)9 Number of permanent data block scratch disk segments acquired in KB.
FilePCiAcqOtherKB FLOAT NOT NULL -(20)9 Number of permanent cylinder index scratch disk segments acquired in KB.
FileSDbAcqOtherKB FLOAT NOT NULL -(20)9 Number of regular or restartable spool data block scratch disk segments acquired in KB.
FileSCiAcqOtherKB FLOAT NOT NULL -(20)9 Number of regular or restartable spool cylinder index scratch disk segments acquired in KB.
FileTJtAcqOtherKB FLOAT NOT NULL -(20)9 Number of transient journal or WAL data block or WAL cylinder index scratch disk segments acquired in KB.
FileAPtAcqOtherKB FLOAT NOT NULL -(20)9 Number of append table or permanent journal table data block or cylinder index scratch disk segments acquired in KB.
FilePDbRelOtherKB FLOAT NOT NULL -(20)9 Number of scratch permanent data block disk segments released in KB.
FilePCiRelOtherKB FLOAT NOT NULL -(20)9 Number of scratch permanent cylinder index disk segments released in KB.
FileSDbRelOtherKB FLOAT NOT NULL -(20)9 Number of scratch regular or restartable spool data block disk segments released in KB.
FileSCiRelOtherKB FLOAT NOT NULL -(20)9 Number of scratch regular or restartable spool cylinder index disk segments released in KB.
FileTJtRelOtherKB FLOAT NOT NULL -(20)9 Number of scratch transient journal table or WAL data block or WAL cylinder index disk segments released in KB.
FileAPtRelOtherKB FLOAT NOT NULL -(20)9 Number of scratch append table or permanent journal table data block or cylinder index disk segments released in KB.
FilePDbAcqReadKB FLOAT NOT NULL -(20)9 KB physically read by FilePDbAcqReads.
FilePCiAcqReadKB FLOAT NOT NULL -(20)9 KB physically read by FilePCiAcqReads.
FileSDbAcqReadKB FLOAT NOT NULL -(20)9 KB physically read by FileSDbAcqReads.
FileSCiAcqReadKB FLOAT NOT NULL -(20)9 KB physically read by FileSCiAcqReads.
FileTJtAcqReadKB FLOAT NOT NULL -(20)9 KB physically read by FileTJtAcqReads.
FileAPtAcqReadKB FLOAT NOT NULL -(20)9 KB physically read by FileAPtAcqReads.
FilePDbPresKB FLOAT NOT NULL -(20)9 Number of KB prefetched by FilePDbPres.
FilePCiPresKB FLOAT NOT NULL -(20)9 Number of KB prefetched by FilePCiPres.
FileSDbPresKB FLOAT NOT NULL -(20)9 Number of KB prefetched by FileSDbPres.
FileSCiPresKB FLOAT NOT NULL -(20)9 Number of KB prefetched by FileSCiPres.
FileTJtPresKB FLOAT NOT NULL -(20)9 Number of KB prefetched by FileTJtPres.
FileAPtPresKB FLOAT NOT NULL -(20)9 Number of KB prefetched by FileAPtPres.
FilePDbPreReadKB FLOAT NOT NULL -(20)9 Number of KB physical read by FilePDbPreReads.
FilePCiPreReadKB FLOAT NOT NULL -(20)9 Number of KB physical read by FilePCiPreReads.
FileSDbPreReadKB FLOAT NOT NULL -(20)9 Number of KB physical read by FileSDbPreReads.
FileSCiPreReadKB FLOAT NOT NULL -(20)9 Number of KB physical read by FileSCiPreReads.
FileTJtPreReadKB FLOAT NOT NULL -(20)9 Number of KB physical read by FileTJtPreReads
FileAPtPreReadKB FLOAT NOT NULL -(20)9 Number of KB physical read by FileAPtPreReads
FilePDbDyRRelKB FLOAT NOT NULL -(20)9 KB released by FilePDbDyRRels.
FilePCiDyRRelKB FLOAT NOT NULL -(20)9 KB released by FilePCiDyRRels.
FileSDbDyRRelKB FLOAT NOT NULL -(20)9 KB released by FileSDbDyRRels.
FileSCiDyRRelKB FLOAT NOT NULL -(20)9 KB released by FileSCiDyRRels.
FileTJtDyRRelKB FLOAT NOT NULL -(20)9 KB released by FileTJtDyRRels.
FileAPtDyRRelKB FLOAT NOT NULL -(20)9 KB released by FileAPtDyRRels.
FilePDbFWriteKB FLOAT NOT NULL -(20)9 KB written by FilePDbFWrites.
FilePCiFWriteKB FLOAT NOT NULL -(20)9 KB written by FilePCiFWrites.
FileSDbFWriteKB FLOAT NOT NULL -(20)9 KB written by FileSDbFWrites.
FileSCiFWriteKB FLOAT NOT NULL -(20)9 KB written by FileSCiFWrites.
FileTJtFWriteKB FLOAT NOT NULL -(20)9 KB written by FileTJtFWrites.
FileAPtFWriteKB FLOAT NOT NULL -(20)9 KB written by FileAPtFWrites.
FilePDbDyAWriteKB FLOAT NOT NULL -(20)9 KB written by FilePDbDyAWrites.
FilePCiDyAWriteKB FLOAT NOT NULL -(20)9 KB written by FilePCiDyAWrites.
FileSDbDyAWriteKB FLOAT NOT NULL -(20)9 KB written by FileSDbDyAWrites.
FileSCiDyAWriteKB FLOAT NOT NULL -(20)9 KB written by FileSCiDyAWrites.
FileTJtDyAWriteKB FLOAT NOT NULL -(20)9 KB written by FileTJtDyAWrites.
FileAPtDyAWriteKB FLOAT NOT NULL -(20)9 KB written by FileAPtDyAWrites.
FilePDbCnRRelKB FLOAT NOT NULL -(20)9 KB released by FilePDbCnRRels.
FilePCiCnRRelKB FLOAT NOT NULL -(20)9 KB released by FilePCiCnRRels.
FileSDbCnRRelKB FLOAT NOT NULL -(20)9 KB released by FileSDbCnRRels.
FileSCiCnRRelKB FLOAT NOT NULL -(20)9 KB released by FileSCiCnRRels.
FileTJtCnRRelKB FLOAT NOT NULL -(20)9 KB released by FileTJtCnRRels.
FileAPtCnRRelKB FLOAT NOT NULL -(20)9 KB released by FileAPtCnRRels.
FilePDbFDrpKB FLOAT NOT NULL -(20)9 KB dropped by FilePDbFDrps.
FilePCiFDrpKB FLOAT NOT NULL -(20)9 KB dropped by FilePCiFDrps.
FileSDbFDrpKB FLOAT NOT NULL -(20)9 KB dropped by FileSDbFDrps.
FileSCiFDrpKB FLOAT NOT NULL -(20)9 KB dropped by FileSCiFDrps.
FileTJtFDrpKB FLOAT NOT NULL -(20)9 KB dropped by FileTJtFDrps.
FileAPtFDrpKB FLOAT NOT NULL -(20)9 KB dropped by FileAPtFDrps.
FilePDbCnADrpKB FLOAT NOT NULL -(20)9 KB dropped by FilePDbCnADrps.
FilePCiCnADrpKB FLOAT NOT NULL -(20)9 KB dropped by FilePCiCnADrps.
FileSDbCnADrpKB FLOAT NOT NULL -(20)9 KB dropped by FileSDbCnADrps.
FileSCiCnADrpKB FLOAT NOT NULL -(20)9 KB dropped by FileSCiCnADrps.
FileTJtCnADrpKB FLOAT NOT NULL -(20)9 KB dropped by FileTJtCnADrps.
FileAPtCnADrpKB FLOAT NOT NULL -(20)9 KB dropped by FileAPtCnADrps.
ReadResponseHotTotal FLOAT NOT NULL -(20)9 Read response time of all cylinders that are considered HOT.
ReadResponseWarmTotal FLOAT NOT NULL -(20)9 Read response time of all cylinders that are considered WARM.
ReadResponseColdTotal FLOAT NOT NULL -(20)9 Read response time of all cylinders that are considered COLD.
WriteResponseHotTotal FLOAT NOT NULL -(20)9 Write response time of all cylinders that are considered HOT.
WriteResponseWarmTotal FLOAT NOT NULL -(20)9 Write response time of all cylinders that are considered WARM.
WriteResponseColdTotal FLOAT NOT NULL -(20)9 Write response time of all cylinders that are considered COLD.
FilePreCompMB FLOAT NOT NULL -(20)9 Total number of MBs for the data block to compress before any compression starts. This column is used with the FilePostCompMB column to calculate the compression ratio.
FilePostCompMB FLOAT NOT NULL -(20)9 Total number of MBs of compressed data that result from uncompressed blocks being compressed. This column is used with the FilePreCompMB column to calculate the compression ratio.
FilePreUnCompMB FLOAT NOT NULL -(20)9 Total number of MBs for the compressed data block to uncompress before uncompression starts. This column is used with the FilePostUncompMB column to calculate the uncompression ratio.
FilePostUnCompMB FLOAT NOT NULL -(20)9 Total number of MBs of uncompressed data that result from compressed blocks being uncompressed. This column is used with the FilePreUncompMB column to calculate the uncompression ratio.
FileCompCPU FLOAT NOT NULL -(20)9 Compression time, including any overhead. The column measures, in microseconds, the time it takes from the beginning of the compression operation to the end.
FileUnCompCPU FLOAT NOT NULL -(20)9 Uncompression time, including any overhead. The column measures, in microseconds, the time it takes from the beginning of the uncompression operation to the end.
FileTempCPU FLOAT NOT NULL -(20)9 CPU time, in microseconds, spent by the AutoTempComp background task either compressing or uncompressing data, including any overhead.
VHAgedOut FLOAT NOT NULL -(20)9 Number of data segments that were aged out of VERY-HOT cache.
VHAgedOutKB FLOAT NOT NULL -(20)9 Volume of data segments in KB that were aged out of VERY-HOT cache.
VHLogicalDBRead FLOAT NOT NULL -(20)9 Number of logical db reads from VH cache.
VHLogicalDBReadKB FLOAT NOT NULL -(20)9 Volume of logical reads in KB from VERY-HOT cache.
VHPhysicalDBRead FLOAT NOT NULL -(20)9 Number of physical db reads from VH cache.
VHPhysicalDBReadKB FLOAT NOT NULL -(20)9 KB of physical reads for VH data.
VHCacheInuseKB FLOAT NOT NULL -(20)9 Size of VH cache in KB in use.
FsgCacheInuseKB FLOAT NOT NULL -(20)9 KB of FSG cache in use. This includes the memory in use by TIM (VHCacheInuseKB).
SpaceAllocated FLOAT NOT NULL -(20)9 Total number of bytes of space allocated to the AMP VPROC.
SpaceDeallocated FLOAT NOT NULL -(20)9 Total number of bytes of space de-allocated from the AMP VPROC.
NosPhysReadIOs FLOAT NOT NULL -(20)9 Number of physical read IOs issued against Native Object Store tables.
NosPhysReadIOKB FLOAT NOT NULL -(20)9 Total KB physically read from Native Object Store tables.
NosFiles FLOAT NOT NULL -(20)9 Number of Native Object Store files read in satisfying queries against Native Object Store tables.
NosFilesSkipped FLOAT NOT NULL -(20)9 Number of Native Object Store files (or partial files) skipped due to errors.
NosRecordsReturned FLOAT NOT NULL -(20)9 Number of records returned in satisfying queries against Native Object Store tables.
NosRecordsReturnedKB FLOAT NOT NULL -(20)9 Total KB of records returned from Native Object Store files.
NosRecordsSkipped FLOAT NOT NULL -(20)9 Number of Native Object Store records skipped due to errors.
NosTotalIOWaitTime FLOAT NOT NULL -(20)9 Total time in seconds waiting for IOs when reading Native Object Store files.
NosMaxIOWaitTime FLOAT NOT NULL -(20)9 Maximum single IO wait time in seconds when reading Native Object Store files.
NosCPUTime FLOAT NOT NULL -(20)9 Total CPU time in seconds spend decompressing, translating, or otherwise processing Native Object Store data as part of reading it.
RRDHCount FLOAT NOT NULL -(20)9 Total count of hashed row redistributions (RRDs) processed by the node-level buffered redistribution services (NLB).
RRDHCascAll FLOAT NOT NULL -(20)9 Count of hashed RRDs with a Cascade Factor of 100%.
RRDHCascMost FLOAT NOT NULL -(20)9 Count of hashed RRDs with a Cascade Factor of 90 or more, but less than 100%%.
RRDHCascSome FLOAT NOT NULL -(20)9 Count of hashed RRDs with a Cascade Factor greater than 0% but less than 90%.
NosPhysDataReadIO FLOAT NOT NULL -(20)9 Number of Physical Data IO Reads for Native Object Store.
NosPhysDataReadIOKB FLOAT NOT NULL -(20)9 Total KBs of physical data read for Native Object Store.
NosCacheReadIO FLOAT NOT NULL -(20)9 Number of Cache Data IO Reads for Native Object Store.
FileSpoolForceAgeoutnow FLOAT NOT NULL -(20)9 Number of spool data segments that were forced to change their age to ageoutnow.
FileSpoolForceAgeoutnowKB FLOAT NOT NULL -(20)9 Volume of spool data segments in KB that were forced to change their age to ageoutnow.
FileSpoolKeepAge FLOAT NOT NULL -(20)9 Number of spool data segments that keep their age irrespective of FSGINFOSPOOLAGEOUTNOW flag.
FileSpoolKeepAgeKB FLOAT NOT NULL -(20)9 Volume of spool data segments in KB that keep their age irrespective of FSGINFOSPOOLAGEOUTNOW flag.
NosCacheReadIOKB FLOAT NOT NULL -(20)9 Total KBs of cache data read for Native Object Store.
CISleeps FLOAT NOT NULL -(20)9 Number of times that processes are blocked waiting for a lock on the CI.
CISleepTime FLOAT NOT NULL -(20)9 Total amount of time in milliseconds that processes are blocked waiting for a lock on the CI.
CISleepTimeMax FLOAT NOT NULL -(20)9 Maximum amount of time in milliseconds that processes are blocked waiting for a lock on the CI.
MsgAwtWorkDQCount FLOAT NOT NULL -(20)9 Number of messages dequeued for AMP Worker Tasks.
FileWalTJCount FLOAT NOT NULL -(20)9 Number of Transient Journal records operations.
FileWalRedoCount FLOAT NOT NULL -(20)9 Number of Redo records operations.
FileWalTJIOKB FLOAT NOT NULL -(20)9 Volume of Transient Journal records operations in terms of KB.
FileWalRedoIOKB FLOAT NOT NULL -(20)9 Volume of Redo records operations in terms of KB.
NosFilesWritten FLOAT NOT NULL -(20)9 Number of file writes attempted by Native Object Store.
NosPhysWriteIOs FLOAT NOT NULL -(20)9 Total physical write IOs for Native Object Store.
NosPhysWriteIOKB FLOAT NOT NULL -(20)9 Total KB of physical write IOs for Native Object Store files.
NosSpCIsReturned FLOAT NOT NULL -(20)9 Number of NOS Spool CIs returned by a Native Object Store Spool request.
NosSpCIsReturnedKB FLOAT NOT NULL -(20)9 Total KB of CIs returned for Native Object Store spool requests.
NosSpDBChunksReturned FLOAT NOT NULL -(20)9 Number of NOS Spool Datablock chunks returned by a Native Object Store spool request.
NosSpDBChunksReturnedKB FLOAT NOT NULL -(20)9 Total KB of NOS Spool Datablock chunks returned by a Native Object Store spool request.
NosSpDBsReturned FLOAT NOT NULL -(20)9 Number of NOS Spool Datablocks returned by a Native Object Store spool request.
NosSpDBsReturnedKB FLOAT NOT NULL -(20)9 Total KB of NOS Spool Datablocks returned by a Native Object Store spool request.
NosSpBlksFSGAcqs FLOAT NOT NULL -(20)9 Number of NOS Spool Datablocks read from FSG.
NosSpBlksFSGAcqsKB FLOAT NOT NULL -(20)9 Total KB of the Number of NOS Spool Datablocks read from FSG.
NosSpCPUTime FLOAT NOT NULL -(20)9 Total CPU time in seconds for reading Native Object Store spool blocks (MI, CI, DBChunks).
NosSpMaxIOWaitTime FLOAT NOT NULL -(20)9 Max Native Object Store spool IO wait time in seconds for any individual IO.
NosSpTotalIOWaitTime FLOAT NOT NULL -(20)9 Total of the Native Object Store spool IO wait time in seconds across all steps.
NosSpTablesWritten FLOAT NOT NULL -(20)9 Number of NOS spool tables written. This corresponds to the number of TMIs written.
NosSpCIsWritten FLOAT NOT NULL -(20)9 Number of NOS Spool CIs written.
NosSpCIsWrittenKB FLOAT NOT NULL -(20)9 Total KB of NOS Spool CIs written.
NosSpDBChunksWritten FLOAT NOT NULL -(20)9 Number of NOS spool DB chunks written.
NosSpDBChunksWrittenKB FLOAT NOT NULL -(20)9 Total KB of NOS spool DB chunks written.
NosSpDBsWritten FLOAT NOT NULL -(20)9 Number of NOS DBs written.
NosSpDBsWrittenKB FLOAT NOT NULL -(20)9 Total KB Number of NOS spool DBs written.
Active FLOAT NOT NULL -(20)9 Controls whether the rows are logged to the resource usage tables if Active Row Filter Mode is enabled.
ProcPendDBLock FLOAT NOT NULL -(20)9 Number of process blocks pending database locks.
ProcBlksDBLock FLOAT NOT NULL -(20)9 Number of process blocks f.or database locks.
ProcWaitDBLock FLOAT NOT NULL -(20)9 Time in centiseconds processes were blocked pending database locks.
MemCtxtAllocs FLOAT NOT NULL -(20)9 Number of successful memory allocations and size-increasing memory alters on task context pages.
MemCtxtAccesses FLOAT NOT NULL -(20)9 Number of segments accessed.
MemCtxtDeaccesses FLOAT NOT NULL -(20)9 Number of segments deaccessed. Deaccessed segments remain in memory until paged out through aging.
MemCtxtDestroys FLOAT NOT NULL -(20)9 Number of segments destroyed. Destroyed segments are immediately dropped from memory.
NetPtPReads FLOAT NOT NULL -(20)9 Number of point-to-point messages input to the vproc.
NetPtPWrites FLOAT NOT NULL -(20)9 Number of point-to-point messages output from the vproc.
NetBrdReads FLOAT NOT NULL -(20)9 Number of broadcast messages input to the vproc.
NetBrdWrites FLOAT NOT NULL -(20)9 Number of broadcast messages output from the vproc.
DBLockEnters FLOAT NOT NULL -(20)9 Number of times a database lock was entered for holding.
DBLockBlocks FLOAT NOT NULL -(20)9 Number of times a database lock was blocked.
DBLockDeadlocks FLOAT NOT NULL -(20)9 Number of times a database lock was deadlocked.
FilePDbAcqs FLOAT NOT NULL -(20)9 Number of permanent data block disk segments acquires that were logically acquired.
FilePCiAcqs FLOAT NOT NULL -(20)9 Number of permanent cylinder index disk segments acquires that were logically acquired.
FileSDbAcqs FLOAT NOT NULL -(20)9 Number of regular or restartable spool data block disk segments acquires that were logically acquired.
FileSCiAcqs FLOAT NOT NULL -(20)9 Number of regular or restartable spool cylinder index disk segments acquires that were logically acquired.
FileTJtAcqs FLOAT NOT NULL -(20)9 Number of transient journal or WAL data block or WAL cylinder index disk segments acquires that were logically acquired.
FileAPtAcqs FLOAT NOT NULL -(20)9 Number of append table or permanent journal table data block or cylinder index disk segments that were logically acquired.
FilePDbAcqsOther FLOAT NOT NULL -(20)9 Number of permanent data block scratch disk segments that were logically acquired.
FilePCiAcqsOther FLOAT NOT NULL -(20)9 Number of permanent cylinder index scratch disk segments that were logically acquired.
FileSDbAcqsOther FLOAT NOT NULL -(20)9 Number of regular or restartable spool data block scratch disk segments that were logically acquired.
FileSCiAcqsOther FLOAT NOT NULL -(20)9 Number of regular or restartable spool cylinder index scratch disk segments that were logically acquired.
FileTJtAcqsOther FLOAT NOT NULL -(20)9 Number of transient journal or WAL data block or WAL cylinder index scratch disk segments that were logically acquired.
FileAPtAcqsOther FLOAT NOT NULL -(20)9 Number of append table or permanent journal table data block or cylinder index scratch disk segments that were logically acquired.
FilePDbRelsOther FLOAT NOT NULL -(20)9 Number of scratch permanent data block disk segments released as part of them being deleted.
FilePCiRelsOther FLOAT NOT NULL -(20)9 Number of scratch permanent cylinder index disk segments released as part of them being deleted.
FileSDbRelsOther FLOAT NOT NULL -(20)9 Number of scratch regular or restartable spool data block disk segments released as part of them being deleted.
FileSCiRelsOther FLOAT NOT NULL -(20)9 Number of scratch regular or restartable spool cylinder index disk segments released as part of them being deleted.
FileTJtRelsOther FLOAT NOT NULL -(20)9 Number of scratch transient journal table or WAL data block or WAL cylinder index disk segments released as part of them being deleted.
FileAPtRelsOther FLOAT NOT NULL -(20)9 Number of scratch append table or permanent journal table data block or cylinder index disk segments released as part of them being deleted.
FilePDbAcqReads FLOAT NOT NULL -(20)9 Number of permanent data block disk segment acquires that caused a physical read.
FilePCiAcqReads FLOAT NOT NULL -(20)9 Number of permanent cylinder index disk segment acquires that caused a physical read.
FileSDbAcqReads FLOAT NOT NULL -(20)9 Number of regular or restartable spool data block disk segments that caused a physical read.
FileSCiAcqReads FLOAT NOT NULL -(20)9 Number of regular or restartable spool index disk segments that caused a physical read.
FileTJtAcqReads FLOAT NOT NULL -(20)9 Number of transient journal table disk segments that caused a physical read.
FileAPtAcqReads FLOAT NOT NULL -(20)9 Number of append table or permanent journal table data block or cylinder index disk segments that caused a physical read.
FilePDbPres FLOAT NOT NULL -(20)9 Number of permanent data block disk segments prefetched.
FilePCiPres FLOAT NOT NULL -(20)9 Number of permanent cylinder index disk segments prefetched.
FileSDbPres FLOAT NOT NULL -(20)9 Number of regular or restartable spool data block disk segments prefetched.
FileSCiPres FLOAT NOT NULL -(20)9 Number of regular or restartable spool index disk segments prefetched.
FileTJtPres FLOAT NOT NULL -(20)9 Number of transient journal table disk segments prefetched.
FileAPtPres FLOAT NOT NULL -(20)9 Number of append table or permanent journal table data block or cylinder index disk segments prefetched.
FilePDbPreReads FLOAT NOT NULL -(20)9 Number of permanent data block disk segment prefetches that caused a physical read.
FilePCiPreReads FLOAT NOT NULL -(20)9 Number of permanent cylinder index disk segment prefetches that caused a physical read.
FileSDbPreReads FLOAT NOT NULL -(20)9 Number of regular or restartable spool data block disk segment prefetches that caused a physical read.
FileSCiPreReads FLOAT NOT NULL -(20)9 Number of regular or restartable spool index disk segment prefetches that caused a physical read.
FileTJtPreReads FLOAT NOT NULL -(20)9 Number of transient journal table disk segment prefetches that caused a physical read.
FileAPtPreReads FLOAT NOT NULL -(20)9 Number of append table or permanent journal table data block or cylinder index disk segment prefetches that caused a physical read.
FilePDbDyRRels FLOAT NOT NULL -(20)9 Number of dirty permanent data block disk segment resident releases.
FilePCiDyRRels FLOAT NOT NULL -(20)9 Number of dirty permanent cylinder index disk segment resident releases.
FileSDbDyRRels FLOAT NOT NULL -(20)9 Number of dirty regular or restartable spool data block disk segment resident releases.
FileSCiDyRRels FLOAT NOT NULL -(20)9 Number of dirty regular or restartable spool cylinder index disk segment resident releases.
FileTJtDyRRels FLOAT NOT NULL -(20)9 Number of dirty transient journal table or WAL data block or WAL cylinder index disk segment resident releases.
FileAPtDyRRels FLOAT NOT NULL -(20)9 Number of dirty append table and permanent journal data block or cylinder index disk segment resident releases.
FilePDbFWrites FLOAT NOT NULL -(20)9 Number of permanent data block disk segment forced releases or specific I/O requests causing an immediate physical write.
FilePCiFWrites FLOAT NOT NULL -(20)9 Number of permanent cylinder index disk segment forced releases or specific I/O requests causing an immediate physical write.
FileSDbFWrites FLOAT NOT NULL -(20)9 Number of regular or restartable spool data block disk segment forced releases or specific I/O requests causing an immediate physical write.
FileSCiFWrites FLOAT NOT NULL -(20)9 Number of regular or restartable spool cylinder index disk segment forced releases or specific I/O requests causing an immediate physical write.
FileTJtFWrites FLOAT NOT NULL -(20)9 Number of transient journal table or WAL data block or WAL cylinder index disk segment forced releases or specific I/O requests causing an immediate physical write.
FileAPtFWrites FLOAT NOT NULL -(20)9 Number of append table and permanent journal data block or cylinder index disk segment forced releases or specific I/O requests causing an immediate physical write.
FilePDbDyAWrites FLOAT NOT NULL -(20)9 Number of dirty permanent data block disk segments aged out of memory causing a delayed physical write.
FilePCiDyAWrites FLOAT NOT NULL -(20)9 Number of dirty permanent cylinder index disk segments aged out of memory causing a delayed physical write.
FileSDbDyAWrites FLOAT NOT NULL -(20)9 Number of dirty regular or restartable spool data block disk segments aged out of memory causing a delayed physical write.
FileSCiDyAWrites FLOAT NOT NULL -(20)9 Number of dirty regular or restartable spool cylinder index disk segments aged out of memory causing a delayed physical write.
FileTJtDyAWrites FLOAT NOT NULL -(20)9 Number of dirty transient journal table or WAL data block or WAL cylinder index disk segments aged out of memory causing a delayed physical write.
FileAPtDyAWrites FLOAT NOT NULL -(20)9 Number of dirty append table or permanent journal table data block or cylinder index disk segments aged out of memory causing a delayed physical write.
FilePDbCnRRels FLOAT NOT NULL -(20)9 Number of clean permanent data block disk segment resident releases.
FilePCiCnRRels FLOAT NOT NULL -(20)9 Number of clean permanent cylinder index disk segment resident releases.
FileSDbCnRRels FLOAT NOT NULL -(20)9 Number of clean regular or restartable spool data block disk segment resident releases.
FileSCiCnRRels FLOAT NOT NULL -(20)9 Number of clean regular or restartable spool cylinder index disk segment resident releases.
FileTJtCnRRels FLOAT NOT NULL -(20)9 Number of clean transient journal table or WAL data block or WAL cylinder index disk segment resident releases.
FileAPtCnRRels FLOAT NOT NULL -(20)9 Number of clean append table or permanent journal table data block or cylinder index disk segment resident releases.
FilePDbFDrps FLOAT NOT NULL -(20)9 Number of permanent data block disk segment forced releases causing an immediate memory drop.
FilePCiFDrps FLOAT NOT NULL -(20)9 Number of permanent cylinder index disk segment forced releases causing an immediate memory drop.
FileSDbFDrps FLOAT NOT NULL -(20)9 Number of regular or restartable spool data block disk segment forced releases causing an immediate memory drop.
FileSCiFDrps FLOAT NOT NULL -(20)9 Number of regular or restartable spool cylinder index disk segment forced releases causing an immediate memory drop.
FileTJtFDrps FLOAT NOT NULL -(20)9 Number of transient journal table or WAL data block or WAL cylinder index disk segment forced releases causing an immediate memory drop.
FileAPtFDrps FLOAT NOT NULL -(20)9 Number of append table or permanent journal table data block or cylinder index disk segment forced releases causing an immediate memory drop.
FilePDbCnADrps FLOAT NOT NULL -(20)9 Number of clean permanent data block disk segments aged out of memory.
FilePCiCnADrps FLOAT NOT NULL -(20)9 Number of clean permanent cylinder index disk segments aged out of memory.
FileSDbCnADrps FLOAT NOT NULL -(20)9 Number of clean regular or restartable spool data block disk segments aged out of memory.
FileSCiCnADrps FLOAT NOT NULL -(20)9 Number of clean regular or restartable spool cylinder index disk segments aged out of memory.
FileTJtCnADrps FLOAT NOT NULL -(20)9 Number of clean transient journal table or WAL data block or WAL cylinder index disk segments aged out of memory.
FileAPtCnADrps FLOAT NOT NULL -(20)9 Number of clean append table or permanent journal table data block or cylinder index disk segments aged out of memory.
FileLockEnters FLOAT NOT NULL -(20)9 Number of lock requests on disk segments.
FileLockBlocks FLOAT NOT NULL -(20)9 Number of lock requests that were blocked. Locks with immediate grants = Total locks - Locks blocked.
FileLockDeadlocks FLOAT NOT NULL -(20)9 Number of deadlocks detected on lock requests.
FileCylMigrs FLOAT NOT NULL -(20)9 Number of cylinder migrations.
FileCylAllocs FLOAT NOT NULL -(20)9 Number of new cylinders allocated.
FileCylFrees FLOAT NOT NULL -(20)9 Number of logical or physical cylinders freed.
FileMCylPacks FLOAT NOT NULL -(20)9 Number of MiniCylPack operations performed.
FileCylDefrags FLOAT NOT NULL -(20)9 Number of cylinder defragments performed.
FileWCylAllocs FLOAT NOT NULL -(20)9 Number of new WAL cylinders allocated.
FileWCylFrees FLOAT NOT NULL -(20)9 Number of times the File System logically frees a cylinder.
FileFcrRequests FLOAT NOT NULL -(20)9 Number of requests for the File System to use Cylinder Read.

Requests issued to FSG = FileFcrRequests - FileFcrDeniedUser.

Successful Cylinder Reads = FileFcrRequests - FileFcrDeniedUser - FileFcrDeniedKern.
FileFcrRequestsAdaptive FLOAT NOT NULL -(20)9 Number of adaptive-style Cylinder Read requests from File System.
FileFcrDeniedUser FLOAT NOT NULL -(20)9 Number of Cylinder Read requests denied by the File System.
FileFcrDeniedCache FLOAT NOT NULL -(20)9 Number of Cylinder Read requests denied by FSG due to insufficient cache.
FileFcrDeniedThreshUser FLOAT NOT NULL -(20)9 Number of Cylinder Read requests denied by the File System due to insufficient data blocks.
FileFcrBlocksRead FLOAT NOT NULL -(20)9 Number of data blocks read in by successful Cylinder Read operations. The average number of data blocks in a successful Cylinder read = Average data blocks/ Cylinder Read = FileFcrBlocksRead / (FileFcrRequests - FileFcrDeniedUser - FileFcrDeniedKern).
FileFcrBlocksDeniedUser FLOAT NOT NULL -(20)9 Number of data blocks contained in the File System rejected requests for Cylinder Read.
FileFcrBlocksDeniedCache FLOAT NOT NULL -(20)9 Number of data blocks contained in Cylinder Read requests rejected by the FSG subsystem due to insufficient cache.
FileFcrBlocksDeniedThreshUser FLOAT NOT NULL -(20)9 Number of data blocks contained in Cylinder Read requests rejected for threshold by the File System.
FileFcrDeniedKern FLOAT NOT NULL -(20)9 Number of Cylinder Read requests denied by the FSG subsystem.
FileFcrDeniedThreshKern FLOAT NOT NULL -(20)9 Number of Cylinder Read requests denied by the FSG subsystem due to insufficient data blocks.
FileFcrBlocksDeniedKern FLOAT NOT NULL -(20)9 Number of data blocks contained in the FSG rejected requests for Cylinder Read.
FileFcrBlocksDeniedThreshKern FLOAT NOT NULL -(20)9 Number of data blocks contained in Cylinder Read requests rejected for threshold by the FSG subsystem.
FileSyncScans FLOAT NOT NULL -(20)9 Number of attempts to synchronize a full table scan.
FileSyncSubtables FLOAT NOT NULL -(20)9 Number of subtables scanned by one or more full table scanners that are willing to synchronize scans.
FileSyncScanners FLOAT NOT NULL -(20)9 Number of tasks involved in full table scans that are willing to synchronize with other scanners.
FileSyncGroups FLOAT NOT NULL -(20)9 Number of groups of scanners involved in full table scans. A group consists of scanners who are able to use the same read I/O to get data from disk.
MsgWorkQLenMax FLOAT NOT NULL -(20)9 Maximum number of work requests waiting during each interval.
MsgChnLastDone FLOAT NOT NULL -(20)9 Number of last done events that occurred for this vproc. The last AMP to finish an operation may send a last done broadcast message indicating the work is done for this step. An AMP with the most last done messages can be a bottleneck in the system.
MsgWorkQLen FLOAT NOT NULL -(20)9 Number of work requests waiting at the current time.
CPUUServPart00 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 0 (Kernel: PDE daemons).
CPUUServPart01 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 1 (System Debugger).
CPUUServPart02 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 2 (Console Supervisor).
CPUUServPart03 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 3 (Console Interactive programs).
CPUUServPart04 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 4 (Console Interactive programs).
CPUUServPart05 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 5 (Console Interactive programs).
CPUUServPart06 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 6 (Console Interactive programs).
CPUUServPart07 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 7 (Service: Console utilities).
CPUUServPart08 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 8 (CNSproc: Host Utility console).
CPUUServPart09 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 9 (File System processes).
CPUUServPart10 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 10 (Gateway processes).
CPUUServPart11 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 11 (AWT).
CPUUServPart12 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 12 (Session control tasks).
CPUUServPart13 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 13 (Dispatcher/Parser).
CPUUServPart14 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 14 (Unused).
CPUUServPart15 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 15 (Startup tasks).
CPUUServPart16 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 16 (Unused).
CPUUServPart17 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 17 (RSS Startup).
CPUUServPart18 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 18 (DDF services).
CPUUServPart19 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 19 (Metadata Services Gateway rsgmain).
CPUUServPart20 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 20 (Unused).
CPUUServPart21 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 21 (Unused).
CPUUServPart22 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 22 (Unused).
CPUUServPart23 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 23 (Unused).
CPUUServPart24 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 24 (Unused).
CPUUServPart25 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 25 (Unused).
CPUUServPart26 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 26 (Unused).
CPUUServPart27 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 27 (Unused).
CPUUServPart28 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 28 (Unused).
CPUUServPart29 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 29 (Unused).
CPUUServPart30 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 30 (Unused).
CPUUServPart31 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 31 (Allocator services).
CPUUServPart32 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 32 (Node Agent services).
CPUUServPart33 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 33 (Clique Coordinator services).
CPUUServPart34 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 34 (Unused).
CPUUServPart35 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 35 (Unused).
CPUUServPart36 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 36 (Unused).
CPUUServPart37 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 37 (Unused).
CPUUServPart38 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 38 (Unused).
CPUUServPart39 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 39 (Unused).
CPUUServPart40 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 40 (Unused).
CPUUServPart41 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 41 (Unused).
CPUUServPart42 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 42 (Unused).
CPUUServPart43 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 43 (Unused).
CPUUServPart44 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 44 (Unused).
CPUUServPart45 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 45 (Unused).
CPUUServPart46 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 46 (Unused).
CPUUServPart47 FLOAT NOT NULL -(20)9 System-level CPU time in centiseconds spent doing work for partition 47 (Replication Gateway rsgdbsmain).
CPUUExecPart00 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 0 (Kernel: PDE daemons).
CPUUExecPart01 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 1 (System Debugger).
CPUUExecPart02 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 2 (Console Supervisor).
CPUUExecPart03 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 3 (Console Interactive programs).
CPUUExecPart04 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 4 (Console Interactive programs).
CPUUExecPart05 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 5 (Console Interactive programs).
CPUUExecPart06 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 6 (Console Interactive programs).
CPUUExecPart07 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 7 (Service: Console utilities).
CPUUExecPart08 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 8 (CNSproc: Host Utility console).
CPUUExecPart09 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 9 (File System processes).
CPUUExecPart10 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 10 (Gateway processes).
CPUUExecPart11 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 11 (AWT).
CPUUExecPart12 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 12 (Session control tasks).
CPUUExecPart13 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 13 (Dispatcher/Parser).
CPUUExecPart14 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 14 (Unused).
CPUUExecPart15 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 15 (Startup tasks).
CPUUExecPart16 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 16 (Unused).
CPUUExecPart17 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 17 (RSS Startup).
CPUUExecPart18 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 18 (DDF services).
CPUUExecPart19 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 19 (Metadata Exec Gateway rsgmain).
CPUUExecPart20 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 20 (Unused).
CPUUExecPart21 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 21 (Unused).
CPUUExecPart22 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 22 (Unused).
CPUUExecPart23 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 23 (Unused).
CPUUExecPart24 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 24 (Unused).
CPUUExecPart25 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 25 (Unused).
CPUUExecPart26 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 26 (Unused).
CPUUExecPart27 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 27 (Unused).
CPUUExecPart28 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 28 (Unused).
CPUUExecPart29 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 29 (Unused).
CPUUExecPart30 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 30 (Unused).
CPUUExecPart31 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 31 (Allocator services).
CPUUExecPart32 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 32 (Node Agent services).
CPUUExecPart33 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 33 (Clique Coordinator services).
CPUUExecPart34 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 34 (Unused).
CPUUExecPart35 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 35 (Unused).
CPUUExecPart36 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 36 (Unused).
CPUUExecPart37 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 37 (Unused).
CPUUExecPart38 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 38 (Unused).
CPUUExecPart39 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 39 (Unused).
CPUUExecPart40 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 40 (Unused).
CPUUExecPart41 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 41 (Unused).
CPUUExecPart42 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 42 (Unused).
CPUUExecPart43 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 43 (Unused).
CPUUExecPart44 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 44 (Unused).
CPUUExecPart45 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 45 (Unused).
CPUUExecPart46 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 46 (Unused).
CPUUExecPart47 FLOAT NOT NULL -(20)9 User-level CPU time in centiseconds spent doing work for partition 47 (Replication Gateway rsgdbsmain).
AllocatorExtentAllocReqs FLOAT NOT NULL -(20)9 Number of cylinder allocation requests received by the allocator.
AllocatorExtentFreeReqs FLOAT NOT NULL -(20)9 Number of cylinder free requests received by the allocator.
AllocatorMapIOsStarted FLOAT NOT NULL -(20)9 Number of map I/Os initiated by the allocator.
AllocatorMapIOsDone FLOAT NOT NULL -(20)9 Number of map I/Os completed by the allocator.
NodeAgentMigrationsStarted FLOAT NOT NULL -(20)9 Number of migration requests started by the Node Agent.
NodeAgentMigrationsDone FLOAT NOT NULL -(20)9 Number of migration requests completed by the Node Agent.
NodeAgentStatProcessed FLOAT NOT NULL -(20)9 Number of statistics buffers processed by the Node Agent.
ReadsHot FLOAT NOT NULL -(20)9 Number of reads issued to all cylinders that are considered HOT.
ReadsWarm FLOAT NOT NULL -(20)9 Number of reads issued to all cylinders that are considered WARM.
ReadsCold FLOAT NOT NULL -(20)9 Number of reads issued to all cylinders that are considered COLD.
WritesHot FLOAT NOT NULL -(20)9 Number of writes issued to all cylinders that are considered HOT.
WritesWarm FLOAT NOT NULL -(20)9 Number of writes issued to all cylinders that are considered WARM.
WritesCold FLOAT NOT NULL -(20)9 Number of writes issued to all cylinders that are considered COLD.
ReadResponseHotMax FLOAT NOT NULL -(20)9 Maximum read response time of all cylinders that are considered HOT.
ReadResponseWarmMax FLOAT NOT NULL -(20)9 Maximum read response time of all cylinders that are considered WARM.
ReadResponseColdMax FLOAT NOT NULL -(20)9 Maximum read response time of all cylinders that are considered COLD.
WriteResponseHotMax FLOAT NOT NULL -(20)9 Maximum write response time of all cylinders that are considered HOT.
WriteResponseWarmMax FLOAT NOT NULL -(20)9 Maximum write response time of all cylinders that are considered WARM.
WriteResponseColdMax FLOAT NOT NULL -(20)9 Maximum write response time of all cylinders that are considered COLD.
ReadResponseHotMin FLOAT NOT NULL -(20)9 Minimum read response time of all cylinders that are considered HOT.
ReadResponseWarmMin FLOAT NOT NULL -(20)9 Minimum read response time of all cylinders that are considered WARM.
ReadResponseColdMin FLOAT NOT NULL -(20)9 Minimum read response time of all cylinders that are considered COLD.
WriteResponseHotMin FLOAT NOT NULL -(20)9 Minimum write response time of all cylinders that are considered HOT.
WriteResponseWarmMin FLOAT NOT NULL -(20)9 Minimum write response time of all cylinders that are considered WARM.
WriteResponseColdMin FLOAT NOT NULL -(20)9 Minimum write response time of all cylinders that are considered COLD.
IoRespMax FLOAT NOT NULL -(20)9 Maximum I/O response time in milliseconds on an AMP.
MIWriteLocks FLOAT NOT NULL -(20)9 Number of write locks acquired on a MI.
MIWriteLockTime FLOAT NOT NULL -(20)9 MI write lock hold time in milliseconds.
MIWriteLockTimeMax FLOAT NOT NULL -(20)9 Maximum MI write lock hold time in milliseconds.
MISleeps FLOAT NOT NULL -(20)9 Number of times that processes are blocked waiting for a lock on the MI.
MISleepTime FLOAT NOT NULL -(20)9 Total amount of time in milliseconds that processes are blocked waiting for a lock on the MI.
MISleepTimeMax FLOAT NOT NULL -(20)9 Maximum amount of time in milliseconds that processes are blocked waiting for a lock on the MI.
DBMergeTried FLOAT NOT NULL -(20)9 Number of times the data block being modified tried to be merged with adjacent data blocks as part of the modification.
DBMergeDone FLOAT NOT NULL -(20)9 Number of successful data block merges done. The number of times the data block being modified successfully merged with some number of adjacent data blocks as part of the modification.

DBMergeFailed = DBMergeTried - DBMergeDone.
DBMergeElim FLOAT NOT NULL -(20)9 Number of data blocks eliminated due to data block merges. If n data blocks are merged into one large block, where n is the number of data blocks, this number is incremented by n-1.
DBMergeExtraIO FLOAT NOT NULL -(20)9 Number of additional physical I/Os performed in the data block merge process beyond those done if no data block merges were attempted. This includes any extra I/Os regardless of whether a merge attempt succeeded or not.
FileACPCylsSkipped FLOAT NOT NULL -(20)9 Number of cylinders AutoCylPack skipped when scanning the MI because nothing needed to be done.
FileACPCylsMigr FLOAT NOT NULL -(20)9 Number of successful migrations performed by AutoCylPack.
FileACPCylsUnFSEOnly FLOAT NOT NULL -(20)9 Number of cylinders AutoCylPack could not migrate because of a locking conflict or a cylinder being modified or marked down. Instead, AutoCylPack cleans-up the unfree sector entries (UnFSEs) on all cylinders, except for those that are down.
FileACPCylsPostponed FLOAT NOT NULL -(20)9 Number of cylinders AutoCylPack could not migrate due to conflicts with foreground tasks modifying the cylinder at around the same time as AutoCylPack. AutoCylPack postpones the work until the next time it scans the MI from the beginning.
FileCompDBs FLOAT NOT NULL -(20)9 Number of data blocks compressed.
FileUnCompDBs FLOAT NOT NULL -(20)9 Number of data blocks uncompressed.
FileCompTempDBs FLOAT NOT NULL -(20)9 Number of data blocks compressed by the AutoTempComp background task .
FileUncompTempDBs FLOAT NOT NULL -(20)9 Number of data blocks uncompressed by the AutoTempComp background task .
FileCompCylMigrs FLOAT NOT NULL -(20)9 Number of cylinder migrates done by the AutoTempComp background task. The AutoTempComp background task is responsible for finding the cylinders to compress or decompress based on their temperature.
FileUnCompCylMigrs FLOAT NOT NULL -(20)9 Number of cylinder migrates done by the AutoTempComp background task.
FsgCacheWaits FLOAT NOT NULL -(20)9 Number of times the File System waits for memory to become available in the file segment cache when trying to read data from disk.
FsgCacheWaitTime FLOAT NOT NULL -(20)9 Amount of time the File System waits for memory to become available in the file segment cache when trying to read data from disk.
FsgCacheWaitTimeMax FLOAT NOT NULL -(20)9 Maximum amount of time the File System waits for memory to become available in the File System cache when trying to read data from disk.
UdfServ FLOAT NOT NULL -(20)9 Reported system-level UDF CPU time in centiseconds.
UdfExec FLOAT NOT NULL -(20)9 Reported user execution UDF CPU time in centiseconds.
FileSorts FLOAT NOT NULL -(20)9 Number of sort requests, including the large memory sort requests.
FileLargeMemSorts FLOAT NOT NULL -(20)9 Number of large memory sort requests executed. Large memory sort uses large buffers (1 MB buffers) and up to 1 GB of memory.
FileLargeMemSortsDenied FLOAT NOT NULL -(20)9 Number of large memory sort requests denied.
FileWALBufBusy FLOAT NOT NULL -(20)9 Number of times a WAL append operation resulted in a buffer switch that waited for the next buffer to exit a Busy state.
FileWALSize FLOAT NOT NULL -(20)9 Current size of the WAL log in cylinders. When WAL cylinders are allocated or freed, the counter is increased or decreased by the corresponding number of cylinders.
SpaceProactiveAllocs FLOAT NOT NULL -(20)9 Total number of proactive space allocations made in the AMP VPROC.
SpaceGroupAllocs FLOAT NOT NULL -(20)9 Total number of group space allocations initiated in the AMP VPROC.
SpaceMsgsCnt FLOAT NOT NULL -(20)9 Total number of space allocation and de-allocation messages processed by the space accounting task.
FileCompDBs_HW FLOAT NOT NULL -(20)9 Number of data blocks compressed by HW card.
FileUnCompDBs_HW FLOAT NOT NULL -(20)9 Number of data blocks uncompressed by HW card.
TJPurges FLOAT NOT NULL -(20)9 Number of purge passes in which a block-by-block scan is done.
TJDbPurgeReads FLOAT NOT NULL -(20)9 Number of blocks mapped in during the purge scan.
TJDbPurgeDeletes FLOAT NOT NULL -(20)9 Number of blocks mapped in during the scan that were included in the ranges of blocks that were deleted.
UdfMemInuseKB FLOAT NOT NULL -(20)9 Current total KB of resident memory in use by the UDF secure server processes, excluding the STO child processes.
UdfVmSizeKB FLOAT NOT NULL -(20)9 Current total KB of virtual memory occupied by the UDF secure server processes, excluding the STO child processes.
TDEnabledCPUs FLOAT NOT NULL -(20)9 Number of CPUs available for Teradata tasks at the end of the reporting period.