Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Database Reorgs
It's more a matter of personal philosophy. If you size the database correctly, it should give you 6-12 months of 'elbow room'. If so, then you really won't see much a massive improvement reorging more frequently unless something else is getting out of whack. Of course, if you size it for 6 months normal attrition, and then load in an extra 6000 people that was not planned for, then anything can happen....
Karl M. Nordquist <karln_at_brightwood.com> wrote in article
<33202F7B.117_at_brightwood.com>...
> Stephanie wrote:
> >
> > Question: How frequently do you reorg your databases? What size of
> > databases are you working with when you do this? Do you reorg to simply
> > defragment? or when you reach the hard limit of max extents?
>
Received on Sat Mar 08 1997 - 00:00:00 CST