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.
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. |
None
None
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |