|
|
|
Returns FairCom DB SQL current cache subsystem statistics.
Result Set Fields (2)
Description VARCHAR(64)
Value BIGINT
Example
>call fc_get_cachestats();
DESCRIPTION VALUE
----------- -----
data buffer requests 9860
data buffer hits 9772
index buffer requests 883
index buffer hits 817
index buffer pages in use 15
max index buffers in use 26
available data cache pages 1253
data cache pages in use 57
max data cache pages in use 57
# of index buffers on upd list (tran) 0
# of index buffers on upd list 1
# of data caches on upd list (tran) 0
# of data caches on upd list 0
avail data file special cache pages 626
actual data file special cache pages 0
maximum data file special cache pages 0
16 records returned
