J
Joey Samoy
Guest
Hi, For a 200GB db, we have 2 fixed BI extents at 1GB each. Threshold is set at 2.4GB. Couple of times, we're received the threshold warning, eventually crashing the db down. bistall is not enabled, the bi grew fast that I didn't have time to dbquiet it. to at least know also who/what the user was doing. The parameters have been there for years, we'll most likely hit this scenario again. The regular reaction have been to (gracefully) shutdown db, and truncate bi :-(. With the BI variable extent, I thought that should have handled the bi growing. So I'm thinking of increasing the threshold, but at what value? TIA! on OE 10.2B Enterprise
Continue reading...
Continue reading...