BI FILE usage

[casorohi]

Hi all
I want to monitor/capture the BI file usage at any point of time in MB. Guide me from which VST table I’ll get info or any 4GL code/script.
I have two BI extents one is fixed at 2GB and one is variable.
I am running OE 102B03, on Linux 64bit

Thanks

 

[TomBascom]

_Logging._Logging-BILogSize

or

_dbStatus._dbStatus-BISize

 

[casorohi]

Thanks Tom
Another doubt the value of _dbStatus._dbStatus-BISize is in number of BI blocks ?
I am getting the same value, is this value is HWM, blocks allocated to BI file. ? and which vst I’ll get the bi threshold value .

Thanks

 

[casorohi]

guys any thoughts ? On above doubts?

 

[cj_brandt]

_DbStatus-BiSize can be used to determine the number of bi blocks.
You have to compute the HWM - bi blocks x bi Clustersize