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.


sa_get_dtt( file_id )


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.

DBA authority required

Side effects


See also