Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: size of TableSpace and Performance
Thank you for the hint.
John
<michael_bialik_at_my-deja.com> wrote in message
news:7n2m7h$7h0$1_at_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 - 19:46:57 CDT