DBA_learner
Member
Hello All,
I want to know the exact size of BI file (not physical). For ex: If BI file size is 7 GB and we disconnect the user with long running transaction from long time then the BI file size still remains 7 GB but actual/logical size of BI should get decreased to some value.
I have gone through couple of knowledgebase articles regarding this and found below one relevant where Rob Fitzpatrick has specified the reason that how can we check the actual/logical size of BI file
Help BI architecture
@Rob Fitzpatrick: Logical size of BI file can be determine by: (the number of active BI clusters * the BI cluster size). BI cluster size is available under BI log option of Promon (Like Before-image cluster size: 16384 kb (16777216 bytes) but how can I check the number of active BI clusters and how to calculate these values together.
I think HWM of BI or actual/logical size of BI can be determined by using VST tables. Kindly share if there is any relevant code regarding the same.
Regards,
Learner
I want to know the exact size of BI file (not physical). For ex: If BI file size is 7 GB and we disconnect the user with long running transaction from long time then the BI file size still remains 7 GB but actual/logical size of BI should get decreased to some value.
I have gone through couple of knowledgebase articles regarding this and found below one relevant where Rob Fitzpatrick has specified the reason that how can we check the actual/logical size of BI file
Help BI architecture
@Rob Fitzpatrick: Logical size of BI file can be determine by: (the number of active BI clusters * the BI cluster size). BI cluster size is available under BI log option of Promon (Like Before-image cluster size: 16384 kb (16777216 bytes) but how can I check the number of active BI clusters and how to calculate these values together.
I think HWM of BI or actual/logical size of BI can be determined by using VST tables. Kindly share if there is any relevant code regarding the same.
Regards,
Learner
Last edited: