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: db_block_size

Re: db_block_size

From: Jim Leavitt <jimll_at_halcyon.com>
Date: 1997/11/05
Message-ID: <63qi6m$mtr$1@brokaw.wa.com>#1/1 







You might also consider the transaction mode of your database. Generally,
data warehousing benefits from larger block sizes, OLTP from smaller. Even
for OLTP, I'd stay with the 8K block. I've heard of larger block sizes being
used with data warehouses however.



Jim Leavitt
Received on Wed Nov 05 1997 - 00:00:00 CST












Original text of this message













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