Re: help sizing extents

Hi:

I agree with Jerry's post. I'll add that, post 7.3, Oracle actually recommends picking a single extent size and sticking with it. Tablespace fragmentation = 0.

There's an article on the site below under Performance -> Storage that you might want to read.

Regards,

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original music? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult

Deborah Felmey wrote in message <7psfa5$oia$1_at_autumn.news.rcn.net>...
>I'm an oracle newbie. We are moving our current databases to a new
>platform - we are placing the current datafiles into one datafile when we
>do the conversion - my question is - is there a formula for figuring out
>what the initial extent and next extent will be? How large is too large?
>
>Also - we are running version 7.3.4 - what is the best way to run exports
on
>existing data - for import into the new database?
>
>Any help is greatly appreciated.
>lost in pasadena - deb
>
>
Received on Tue Aug 24 1999 - 20:06:29 CDT