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: How to speed analyzing histograms

Re: How to speed analyzing histograms

From: AnySQL (d.c.b.a) <anysql_at_gmail.com>
Date: 9 Nov 2005 00:53:05 -0800
Message-ID: <1131526385.875140.56830@o13g2000cwo.googlegroups.com> 





You should increase the sort_area_size(100M) and
db_file_multiblock_read_count (128), for big table, please estimate
statistics, for the table which did not change too much, do not need to
analyze them too often.



Welcome, AnySQL


http://www.anysql.net/en/
Received on Wed Nov 09 2005 - 02:53:05 CST












Original text of this message













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