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

Remarks

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.
Permissions

None

Side effects

None

See also