Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: size of TableSpace and Performance
John Seitz 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.
Some Unix's will set a ceiling of 2G on a file which may limit you...Also some Unix's will allow files larger than this but not use asynchronous IO on >2G files...which could hurt performance...
As the other poster said, if you had the choice of 1 x 18G disk and 18 x 1G disks, then you would go the latter - spread, spread, spread your files...
HTH
--
"Some days you're the pigeon, and some days you're the statue." Received on Tue Jul 20 1999 - 08:53:14 CDT