Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Best size for datafiles

Re: Best size for datafiles

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 17 Oct 2001 13:22:56 +0100
Message-ID: <3bcd783b$0$8509$ed9e5944@reading.news.pipex.net>


"Dusan Bolek" <pagesflames_at_usa.net> wrote in message news:1e8276d6.0110170402.5bc36b7f_at_posting.google.com...
> 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.

<snip>
> 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),

Does Solaris support 5gb data files?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Wed Oct 17 2001 - 07:22:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US