Re: filenumber for tablespaces?

From: Manu <emmanuel.pl.bontemps_at_wanadoo.fr>
Date: Mon, 21 Jun 1999 15:08:00 +0200
Message-ID: <7kldg1$j0n$1@oceanite.cybercable.fr>

It's more flexible to have many datafiles of same size (to be able to balance I/O).
The majority of 32 bits Operating System don't accept file greater than 2 GB.
It is possible with HP-UX 10.20, if you create the file system with largesfiles option.
But, I dont know if it is a good thing.

I think that 15/18 GB will be the real size of your table including Oracle overhead.

A propos de ta petite phrase en Francais, que je me permet de corriger :

---

les chats #sont les vrais hédonistes
et devraient #donc être notre idéal.

---

Salut de France

karsten reincke a écrit dans le message <376DEE7C.1B2C613E_at_cl-ki.uni-osnabrueck.de>...
>hello;
>
>we have to manage a table for 4000000 rows each containing more than 3K.
>therefore we must have a tablespace of more than 12 GB.
>
>(1) how many datafiles should we connect to the tablespace?
>(2) is it better to build up the tablespace by many smaller datafiles or
>by one or two very large datafiles?
>
>many thanks for your comments and/or your hints
>--
> salut d'Allemagne kr
>-----------------------------------
>les chats cont les vrais hédonistes
>et devraient être donc notre idéal.
>-----------------------------------
> karsten reincke [ 0541/9696223 ]
> kreincke_at_cl-ki.uni-osnabrueck.de
Received on Mon Jun 21 1999 - 08:08:00 CDT