Structure

---

CREATE TABLE "FileIOStatistics"
(
"FileName" VARCHAR(40) COLLATE "ANSI_CI",
"BlockSize" INTEGER,
"MaxSize" BIGINT,
"Hits" BIGINT,
"Misses" BIGINT,
"HitRatio" DECIMAL(19,2),
"Reads" BIGINT,
"BytesRead" BIGINT,
"AvgRead" DECIMAL(19,2),
"Writes" BIGINT,
"BytesWritten" BIGINT,
"AvgWrite" DECIMAL(19,2),
"TotalAllocated" BIGINT,
"TotalDirty" BIGINT,
"TotalFlushes" BIGINT
)

CREATE INDEX "FileName" ON "FileIOStatistics"
("FileName")

Description

---

This table reflects the global file I/O buffering statistics for ElevateDB. This information is useful in determining the efficiency of the global file I/O buffering in ElevateDB and whether the file I/O buffering settings may need to be changed. For example, a large number of reads for a file may indicate that you may need to increase the amount of memory allocated for the file. Please see the Buffering and Caching topic for more information.

The current user must be granted the system-defined Administrators role in order to view this table. Please see the User Security topic for more information.

Related DDL Statements

---