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