RE: Autoextend Data files - Pros & Cons

Would you be willing to describe how you do this, for us newbie DBAs?

At 07:57 AM 6/8/00 -0800, you wrote:
> > Advantages: you don't have to worry that someone will run a
> > program that
> > will cause a table to extend and it will fail for lack of space
> >
> > Disadvantages: you don't KNOW that they have extended, so you have to
> > monitor it very carefully, because what you REALLY want to know is if the
> > tables are extending quickly so that you can size them better
> >
>That's why I do trending... I capture growth in tables and indexes, and can
>even see the tablespaces. This is usually weekly, and anything that grows
>more than one extent I take a close look at.

L. Trindle Gennari
Databassist
http://www.peoplescape.com/ Received on Thu Jun 08 2000 - 15:52:38 CDT