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: Extent size

Re: Extent size

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 02 Dec 1999 19:08:58 +0800
Message-ID: <3846534A.2F22@yahoo.com>


Pierre STREEL wrote:
>
> Hi,
>
> I want to optimize my new database. I have 3 types of tables :
> - with 1.000.000 Rows (a lot of insertion in one time)
> - with 100.000 Rows (a lot of insertion in one time)
> - with 10.000 Rows
> - with 1.000 Rows
>
> I created 3 tablespaces for these data :
> - 128 K extent size for the first one
> - 96 K extent size for the second one
> - 64 K extent size for the third
> - 8 K extent size for the last
>
> and 2 tablespace for index, one for the big table and the other for
> small table
>
> Is it good to work like this, is it too much or too small ?
> What's the best solution for storage, in general ?
>
> Thanks in advance :o)
>
> Pierre

I'd maybe look at changing your sizes to (say) 512k for all of them... --



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Dec 02 1999 - 05:08:58 CST

Original text of this message

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