"FileIOActivity" Data Collector
For a detailed discussion of these metrics, see ProTop Real-Time - File IO (f).
To set up an alert on a metric listed here, make note of the Data Collector name at the top of this page, the Alertable Metric and Data Type from the table below and visit Alert Configuration.
Alertable Metric | ProTop RT Label | Data Type | Description |
tt_fileio | (temptable name) | ||
blkSize | BlkSz | num | Block size of the extent |
extArea | Storage Area | char | Name of the storage area associated with the extent |
extExtend | Extends | num | Number of times the extent has been extended |
extMode | Mode | char | BUFfered, UNBUFfered, BOTH. Defines how physical files are opened. Buffered is the normal way, meaning the files are kept in the operating system’s file system cache. Reads and writes happen in this cache. The writes to disk could occur at some later time |
extName | Extent Name | char | Name of the extent defined in the database |
extRead | Reads | num | Number of records read from this extent |
extSize | Size (GB) | num | Extent size in gigabytes |
extWrite | Writes | num | Number of records written to this extent |