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: Tablespace/Datafile Layout for Datawarehouse

Re: Tablespace/Datafile Layout for Datawarehouse

From: EscVector <EscVector_at_gmail.com>
Date: Sat, 09 Jun 2007 04:35:57 -0000
Message-ID: <1181363757.932197.39310@h2g2000hsg.googlegroups.com>


On Jun 9, 12:05 am, Greg Rahn <g..._at_structureddata.org> wrote:
> Why do you limit the data files to only 4GB? If you are using an 8k
> block you can go up to 32GB. This would reduce the amount of open
> file handles.
>
> If the disks are 98+% busy, it's time to add some more spindles.
>
> --
> Regards,
>
> Greg Rahnhttp://structureddata.org

Nice blog. Received on Fri Jun 08 2007 - 23:35:57 CDT

Original text of this message

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