DBA_learner
Member
Hello Everyone,
I have few below mentioned quires regarding BI files. I have shared these after going through couple of articles/discussions.
· Is it possible to add bi extent online if last bi extent is variable or fixed length without -bithold –bistall startup parameter? Or can we do it when -bithold –bistall are defined.
· What is the limit of variable BI extent when large files are enable, is it 5GB or complete drive space where bi extent is mounted.
· Our database has -Bithold 5GB and -Bistall defined and on reaching of its 90% we got BI alert. After that we increase bi threshold value to 6GB from 5GB (via proquiet). I want to know that after updating this threshold value, what all can we do as a solution of this bi increase so that our database shouldn’t shutdown.
Kindly suggest!!!
Regards
I have few below mentioned quires regarding BI files. I have shared these after going through couple of articles/discussions.
· Is it possible to add bi extent online if last bi extent is variable or fixed length without -bithold –bistall startup parameter? Or can we do it when -bithold –bistall are defined.
· What is the limit of variable BI extent when large files are enable, is it 5GB or complete drive space where bi extent is mounted.
· Our database has -Bithold 5GB and -Bistall defined and on reaching of its 90% we got BI alert. After that we increase bi threshold value to 6GB from 5GB (via proquiet). I want to know that after updating this threshold value, what all can we do as a solution of this bi increase so that our database shouldn’t shutdown.
Kindly suggest!!!
Regards