Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: dbms_stats question

RE: dbms_stats question

From: Mladen Gogala <mgogala_at_vmsinfo.com>
Date: Wed, 22 Nov 2006 12:54:09 -0500
Message-ID: <00b101c70e5f$368fe370$232b650a@nycwkswxp2829>


Raj, block sampling is much faster. If you don't use block sampling, DBMS_STATS will read the entire table anyway. The only way to cut down on the number of reads is to use block sampling, but the statistics is much less accurate. You should only use it for the really big, multi-GB tables.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of rjamya Sent: Wednesday, November 22, 2006 6:44 AM To: Oracle Discussion List
Subject: dbms_stats question

I am scanning manual but couldn't find any recommendations on when to
use block sampling and when not to. Are there specific conditions when
block sampling is beneficial and estimate_percent? 10.2.0.2

TIA
Raj



Got RAC?
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 22 2006 - 11:54:09 CST

Original text of this message

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