Re: DB growth

In article <3h8np0$l0c@cssun.mathcs.emory.edu> daniel@genesis.admin.bethel.edu (Dan Madvig - Bethel College & Sem.) writes: >Every night cron gives me a report as to the size of our database. >We've been growing at the rate of about 2-3 Mbytes a week. Last >night we jumped by 60 Mb. Nobody confesses to it. We have some >fast data entry operators, but they're not *that* good. Surely >it's some automated process. > >Anybody have any tools that monitor the growth of each table in an >OnLine database? We're at version 5. > >-- > Dan Madvig e-mail: d-madvig@bethel.edu Note that in Online tables grow in extents, not row by row. If you exceed a certain number of extents on a table, the size of the extent is automatically increased. Check your extent sizes on your active tables. Mat -- W Mat Waites | mat@rencorp.com REN Corporation - USA | (615) 353-4110