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: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 09 Nov 2005 08:03:54 -0800
Message-ID: <1131552236.433524@yasure>


AnySQL (d.c.b.a) wrote:
> 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/

I would consider the chances of this helping anything as being quite low.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Nov 09 2005 - 10:03:54 CST

Original text of this message

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