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: HELP - Terrible query performance on newly partitioned table

Re: HELP - Terrible query performance on newly partitioned table

From: Herman de Boer <h.de.boer_at_itcg.nl>
Date: 4 Jan 2002 23:27:56 -0800
Message-ID: <bde5777e.0201042327.1dccc656@posting.google.com> 





Hello Jim,



just analyze ALL tables with 'estimate statistics',
it takes usually a few seconds per table. Analyzing 
only one table is not sufficient!



Could you send the statement with the hints you tried?
Also, could you send the setting of db_file_multiblock_read_count?



Personally, I don't like setting OPTIMIZER_INDEX_COST_ADJ,
but if it works for you, OK.



Kind Regards,



Herman de Boer.
Received on Sat Jan 05 2002 - 01:27:56 CST












Original text of this message













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