Re: size of TableSpace and Performance

From: <michael_bialik_at_my-deja.com>
Date: Tue, 20 Jul 1999 20:29:56 GMT
Message-ID: <7n2m7h$7h0$1@nnrp1.deja.com>

Hi.

The size of the tablespace does not have any connection to performance, but the I/O spread does. Look at description of Oracle Flexible Architecture ( OFA ) in documentation.
Try to get a number of drives ( as many as possiple ) and to split your files according to OFA ( that a start ).

Good luck. Michael.

In article <uyOk3.168$Ww.2418_at_newse3.tampabay.rr.com>, "John Seitz" <seitz_at_pobox.com> wrote:
> Is there any relationship between the size of a tablespace and
performance
> on queries. I'm creating a database, and I would like to make the
> tablespace 4 gigs. However, currently I know that the amount of data
will
> not go over 1 gig. But I would like to plan for the future. I don't
want
> to have to deal with the database that much.
>
> Am I on crack for thinking this? I know that I can added datafiles as
> needed, but I really don't want to do that. And its not like the
server
> doesn't have the room. Its a 18 gig drive.
>
> Will the large tablespace degrade performance?
>
> John Seitz
>
> PS: sorry for the newbie, and thank you in advance.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 20 1999 - 15:29:56 CDT