Re: The cardinality of tablespace and datafile

It is not wise to dedicate disks for certain functions. The best and simplest thing to do is stripe over as many disks as you can .....

Point 2 is old and has never been true and can really hurt performance/throughput of your database

Also remember Databases is about disks/IOs not number of files ! (1 disk with 10 files or 1 file will perform as bad).

Waiting for replies ;-)

Anjo.

Andreas Stephan wrote:

> Hi Chuan,
>
> here are some rules I use when I install a database:
>
> 1) never put rollback segment tablespace on a drive containig data (table) or
> index tablespaces
> 2) never put data and index tablespaces on the same drive if they interact
> 3) use a max of 2Gig Datafiles to keep maintenance simpler and to avoid
> unnecessary recovery time
> (it is easier and quicker to recover one 2 Gig Datafile than one of 20 Gig).
> You can transport a
> 2 Gig Datafile on an old dat tape but with 20 Gigs?? And copying from tape
> to disk or over the lan
> will not cause any problems if you have only 2 Gig Datafiles.
> 4) try to use partitioned tablespaces if possible. Split the data onto the
> partitions. Each partition should
> reside on a separate drive to maximize performance
>
> putting datafile on different drives will only help if you have more than one
> tablespace and your objects are
> well separated onto these tablespaces (index objects in index tablespaces,
> tables in data tablespaces, tables that
> are often joined moved into separate tablespaces on separate disks or
> implemented using clusters etc..)
>
> hth
> Andy
>
> chuan zhang schrieb:
>
> > Hi, all,
> >
> > Could anyone tell me that which the following option is better in terms of
> > performance:
> >
> > 1) One tablespace with one big datafile, this datafile might increase more
> > if there are more storage.
> >
> > 2) One tablespace with many small or medium datafiles
> > or
> > 3) Splitting many datafiles into many tablespaces.
> >
> > Note, I have considered to put the datafiles into different drives in order
> > to increase the performance.
> >
> > Thanks
> >
> > Chuan Zhang
> >
> > Asiaonline Ltd Co.
Received on Thu Jun 08 2000 - 00:00:00 CDT