Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » System Procedures » System procedures

sa_get_bits system procedure Next Page

sa_get_dtt system procedure


Reports the current value of the Disk Transfer Time (DTT) model, which is part of the cost model.

Syntax

sa_get_dtt( file_id )

Arguments
Remarks

You can obtain the file_id from the system table SYSFILE.

This procedure, intended for internal diagnostic purposes, retrieves data from the ISYSOPTSTAT system table.

Result set
Column nameData typeDescription
BandSizeUNSIGNED INTEGERSize, in pages, of disk over which random access takes place.
ReadTimeUNSIGNED INTEGERAmortized cost, in microseconds, of reading one page.
WriteTime UNSIGNED INTEGERAmortized cost, in microseconds, of writing one page.
Permissions

DBA authority required

Side effects

None

See also