Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Many samll datafiles better than one big?

Re: Many samll datafiles better than one big?

From: RSH <RSH_Oracle_at_worldnet.att.net>
Date: Tue, 04 Jun 2002 03:24:46 GMT
Message-ID: <2qWK8.20564$LC3.1524133@bgtnsc04-news.ops.worldnet.att.net>


Lothar,

If you are going to be using RAID-5, I cannot see how chopping up your database will help a lot. Unless you have multiple ranks of RAID-5 storage, all your data is stored in one big blob over which you have little physical control, if any.

I usually separate my table-tablespaces and index-tablespaces into different tablespaces and subtending datafiles, more of a matter of management than of performance, since I am not a big fan of self-extending Oracle storage.

RAID-5 automatically scatters your data when it is stored; it is part of its reliability functions and also what can help your performance in queries.

If I were you, I would separate the database logically, and not arbitrarily separate the storage on physical boundaries, given they are meaningless in the RAID-5 environment unless you have multiple controllers and RAID ranks.

That's just my opinion.

RSH.
"Lothar Armbruester" <lothar.armbruester_at_t-online.de> wrote in message news:PM0003A2865959C232_at_hades.none.local...
> Hello out there,
> we will upgrade our database from Oracle 8.1.7 to 9i soon and I thought
> it is a good idea to do some restructuring along.
> Some time ago, I read that tablespaces with many datafile smaller than
> 2GB would perform better than ones with one datafile of, say, 14GB.
> The system will be W2k and the database will be stored on a single
> RAID5. I know that tabelspaces with datafiles spread over many disks
> will perform better but how about having all the small datafiles on one
> volume?
>
> Many thanks in advance,
> Lothar
>
> --
> Lothar Armbrüster | la_at_oktagramm.de
> Hauptstr. 26 | la_at_heptagramm.de
> D-65346 Eltville | lothar.armbruester_at_t-online.de
Received on Mon Jun 03 2002 - 22:24:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US