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

db_block_size

From: <epipko_at_gmail.com>
Date: 19 Sep 2005 16:16:13 -0700
Message-ID: <1127171773.629222.154940@z14g2000cwz.googlegroups.com> 





Hi all,


I have a question about db_block_size.


OS - Win 2003


D/b - Oracle 9.2


We have a reporting d/base with block size of 8192K.
I wonder if we'll have better performance by increasing the block size
to 16 or more, for instanse, since all we do is run "selects.." from
there. I also wonder if pctused/pctfree needs to be modified as well.



Thanks,


Eugene
Received on Mon Sep 19 2005 - 18:16:13 CDT












Original text of this message













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