15.10 - File System: Contiguous Writes Columns - Teradata Database

Teradata Database Resource Usage Macros and Tables

Product
Teradata Database
Release Number
15.10
Published
April 2016
Language
English (United States)
Last Update
2018-05-17
dita:mapPath
Resource_Usage_Macros_15_10.ditamap
dita:ditavalPath
ft:empty

These columns return the number of blocks marked as contiguous writable, the total size of data blocks marked for contiguous writes, and the number of I/Os on blocks marked for contiguous write.

Column Name Mode Description Data Type
FileContigWIos count Number of I/Os completed on data blocks that were marked for contiguous write.

You can get the average number of data blocks combined into a single I/O by using the calculation:

FileContigWBlocks / FileContigWIos

FLOAT
FileContigWBlocks count Number of data blocks marked for contiguous write.

Data blocks created using the contiguous write scheme are accumulated in the cache until the optimal I/O size, the end of the cylinder, or the end of the data created has been reached. At such a point, the blocks will be written with a single I/O and removed from the cache.

FLOAT
FileContigWKB count Total size, in KB, of the data blocks that were marked for contiguous write. You can get the average size of the writes that were candidates for being combined into one single I/O by using the calculation:

FileContigWKB /FileContigWBlocks

FLOAT