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

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Reference » System Objects » System procedures » Alphabetical list of system procedures


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( dbspace_id )
  • dbspace_id   Use this UNSIGNED SMALLINT parameter to specify the database file ID.


You can obtain the dbspace_id from the SYSDBSPACE system view.

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

Result set
Column name Data type Description
BandSize UNSIGNED INTEGER Size, in pages, of disk over which random access takes place.
ReadTime UNSIGNED INTEGER Amortized cost, in microseconds, of reading one page.
WriteTime UNSIGNED INTEGER Amortized cost, in microseconds, of writing one page.


Side effects


See also