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: Tuning a Query

Re: Tuning a Query

From: dias <ydias_at_hotmail.com>
Date: 23 Nov 2001 07:40:00 -0800
Message-ID: <55a68b47.0111230739.1a983fbd@posting.google.com> 





> Here are the values of some init.ora parameters requested by some of

> you:

> 

> db_file_multiblock_read_count = 32

> hash_area_size = 16777216

> hash_multiblock_io_count = 0




Hi,


Try to reduce the value for hash_area_size.
You can also try different values for hash_multiblock_io_count (1,2 or 4).



Dias
Received on Fri Nov 23 2001 - 09:40:00 CST












Original text of this message













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