FileIOActivity Data Collector

"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