C
ChUIMonster
Guest
You have a decision to make. You are either going to try to stay ahead of things and (try to) add fixed extents before you start writing to the variable extent *or* you might decide that you're not worried about that and you will just let the fixed extents grow. For many people with small to medium databases the "don't worry about it" option makes a lot of sense. If you have a larger database then you might want to be more proactive. Personally I'm not calling anything less than 1TB "large" anymore and it doesn't really bother me to see 64GB extents. Other people have other opinions. You do need to be careful about getting carried away -- there is a very hard limit of 1TB for an extent and there is no recovery if you try to exceed it. In that case the metric that you probably want to pay attention to is %LastX. That is the percentage full of the last variable extent. In your case, since you are already writing to the variable extent, so %LastX should be 100%. If so then it is too late to be proactive, you have already overflowed, but that's ok, you just end up with a funky sized extent in the middle of all the others. If you are going to be actively managing things commercial ProTop has an alert that fires when the last fixed extent reaches a threshold (generally 80%). (Free ProTop does not fire any alerts.)
Continue reading...
Continue reading...