Re: Large vs. Small Tablespaces?

From: Kevin Brand <kevin.brandx_at_tel.gte.com>
Date: Thu, 10 Jan 2002 11:09:57 -0600
Message-ID: <a1khmf$5ee$1@news.gte.com>

> It is possible to go too far: the more data files you have (ie, the more
> tablespaces you have), the more work CKPT has to do at each checkpoint,
and
> that's a potential performance problem. But you'd have to have hundreds
of
> data files before I reckon you'd notice the degradation.

Indeed. One DBA tried to convince me that the best way to manage tables and spaces was to have a tablespace for each table. Given that we ran OPS with 700+ tables on raw devices, this would have been an absolute nightmare to manage.

Sometimes I wonder what happened to him. Probably somewhere trying to figure out which file he forgot to backup!

-Kevin Received on Thu Jan 10 2002 - 11:09:57 CST