File System Columns | ResUsageSvpr Table | Teradata Vantage - 17.05 - File System: Synchronized Full Table Scans 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 contain statistics relating to synchronized full table scans.

The following columns are moved from the ResUsageIvpr table to the ResUsageSvpr table to avoid costly joins.
Column Name Mode Description Data Type
FileSyncGroups track 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 obtain data from disk. FLOAT
FileSyncScanners track Number of tasks involved in full table scans who are willing to synchronize with other scanners. FLOAT
FileSyncScans count Number of attempts to synchronize a full table scan. FLOAT
FileSyncSubtables track Number of subtables scanned by one or more full table scanners who are willing to synchronize scans. FLOAT