Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Extent size
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... --
"Some days you're the pigeon, and some days you're the statue." Received on Thu Dec 02 1999 - 05:08:58 CST