Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Many samll datafiles better than one big?
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.deReceived on Mon Jun 03 2002 - 11:47:18 CDT