willjamu_at_mindspring.com (James A. Williams) wrote in message news:<3bcd26c9.9000852_at_news.mindspring.com>...
> I am on a Solaris Platform running 8.1.7. I am creating a .5 tb
> datawarehouse.
>
>
> I am going to have a lot of datafiles.
>
> A smaller datafile spread out generally performs better.
>
>
> I like 500 mb but will go with 1000 mb files.
>
I do not thing that 1000MB or even 500 MB is a good datafile size for
0.5 TB data warehouse. Maybe you should consider larger datafiles,
because 500 (1000) data_files would be a nightmare to administer.
You can have 5000MB data files (100 of them), but you should carefully
plan your partition policy for your biggest tables to improve read
performance.
You must begin with internal analysis and after that, you can move to
deciding data files layout.
You'll need to know your enemy (the biggest tables), before throwing
out numbers like 500 MB, 1000 MB.
Maybe you have been already doing that, but from your question it was
unsure.
--
_________________________________________
Dusan Bolek, Ing.
Oracle team leader
Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.
Received on Wed Oct 17 2001 - 07:02:32 CDT
