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: Eagle Fan <eagle.f_at_gmail.com>
Date: 19 Sep 2005 23:08:21 -0700
Message-ID: <1127196501.616972.318690@g47g2000cwa.googlegroups.com> 





hi:



I think setting the parameter db_file_multiblock_read_count will help
you if you always do multiple-blocks scan.



You can test it to find out the best value.



If you nerver update the data, you can set the pctused to 0(or a small
value) .
Received on Tue Sep 20 2005 - 01:08:21 CDT












Original text of this message













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