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