Native Object Store 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ā„¢
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