Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Usage of the dbms_stats.gather_database_stats() procedure
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-lReceived on Mon Feb 13 2006 - 16:00:50 CST
![]() |
![]() |