Re: Resizing Data Files...

Yes and No... Yes..if For example of a 500MB file...you could have had two 250MB datafiles on seperate disks (and perferablly, different controllers). If there is another option that will allow striping along avaible dedicated drives, then yes...you hurt your performance.

No...If you don't have the drives availble. I can think of no advantages (performance wise) to two 250MB Datafiles or one 500MB datafile on the same drive.

I personally increase the size of my datafiles to 2GB max. If I need a tablespace to be more than 2GB, then I add an additional Datafile.

Good Luck,
Satar

In article <JJzW1.340$5d.553331_at_newsread.com!newshog.newsread.com>,   "Mike Oswald" <minomaha_at_hotmail.com> wrote:
> Do to space constraints and trying to get the most out of what space we do
> have allocated to our Oracle instances... I resized all the datafiles in an
> instance. For example, we are using raw datafiles and I changed them from
> 480m to 499m. Not much of a change... but enough to help ...
>
> Anyway... is there a performance hit by doing this? Something we should
> have considered?
>
> Thanks!
>
> -Mike
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 20 1998 - 16:04:49 CDT