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 -> 64-bit 8.1.6.2 Optimal Block Size for Data Warehouse?

64-bit 8.1.6.2 Optimal Block Size for Data Warehouse?

From: <solxrosenberg_at_my-deja.com>
Date: Fri, 12 Jan 2001 16:03:31 GMT
Message-ID: <93n9sb$hii$1@nnrp1.deja.com> 






I'm building a star schema using 64-bit Oracle 8.1.6.2 on a 12-way HP
v2500 running HPUX11 and using EMC disk arrays.  My fact table (10
numeric columns) has 1 billion rows total across 24 partitions.  I
have 5 dimension tables.  My current Block Size is 8k.  What are the
pros and cons of upping it to 16k or 32k?  Most of the queries against
this schema will use Oracle's Star Transformation.
Thanks!




Sent via Deja.com


http://www.deja.com/
Received on Fri Jan 12 2001 - 10:03:31 CST












Original text of this message













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