Re: how many tablespaces
From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Thu, 04 Mar 2004 04:34:59 GMT
Message-ID: <Tly1c.112729$4o.138921_at_attbi_s52>
Date: Thu, 04 Mar 2004 04:34:59 GMT
Message-ID: <Tly1c.112729$4o.138921_at_attbi_s52>
"Vissu" <vissuyk_at_yahoo.com> wrote in message
news:2bedd6a7.0403032012.2899a4a6_at_posting.google.com...
> Hi ,
>
> We will have about 50 tables. Some tables will be huge (severel
> million rows) and some are small but most of them will have about a
> million rows. For best performance of the database, how many
> tablespace should I have. I was thinking of using Locally Managed
> tablespaces (uniform extents) for both data and indexes.
>
> Can anyone share some experiences? Any other tips on layout of the
> database will be appreciated. Thanks
>
> Vissu
What version? Use locally managed with auto managed extents and put the
data all in one tablespace.
Jim
Received on Thu Mar 04 2004 - 05:34:59 CET