Native Object Store Columns - Advanced SQL Engine - Teradata Database

Resource Usage Macros and Tables

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
dep1592878989156.ditamap
dita:ditavalPath
dep1592878989156.ditaval
dita:id
B035-1099
lifecycle
previous
Product Category
Teradata Vantageā„¢
Column Name Mode Description Data Type
NosPhysReadIOs count Number of physical read IOs issued against Native Object Store tables. FLOAT
NosPhysReadIOKB count Total KB physically read from Native Object Store tables. FLOAT
NosFiles count Number of Native Object Store files read in satisfying queries against Native Object Store tables. FLOAT
NosFilesSkipped count Number of Native Object Store files skipped due to errors. FLOAT
NosRecordsReturned count Number of records returned in satisfying queries against Native Object Store tables. FLOAT
NosRecordsReturnedKB count Total KB of records returned from Native Object Store files (after any decompression and character conversion performed). FLOAT
NosRecordsSkipped count Number of Native Object Store records skipped due to errors FLOAT
NosTotalIOWaitTime count Total time in seconds waiting for IOs when reading Native Object Store files. FLOAT
NosMaxIOWaitTime max Maximum single IO wait time in seconds when reading Native Object Store files. FLOAT
NosCPUTime count Total CPU time in seconds spend decompressing, translating, or otherwise processing Native Object Store data as part of reading it. FLOAT
NosFilesWritten count Number of file writes attempted by Native Object Store. FLOAT
NosPhysWriteIOs count Total physical write IOs for Native Object Store files. FLOAT
NosPhysWriteIOKB count Total KB of physical write IOs for Native Object Store files. FLOAT