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: Usage of the dbms_stats.gather_database_stats() procedure

Re: Usage of the dbms_stats.gather_database_stats() procedure

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 13 Feb 2006 14:00:50 -0800
Message-ID: <bf46380602131400r508dac35v2827a56a1a467b96@mail.gmail.com> 





On 2/13/06, Orr, Steve <sorr_at_rightnow.com> wrote:


>

> Any other stats maintenance recommendations?

>




Consider using block_sample => true.



Otherwise your samples may read much more of the database than you intended.


--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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


Received on Mon Feb 13 2006 - 16:00:50 CST












Original text of this message













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