RE: Portable DBA: Oracle

From: Freeman Robert - IL <FREEMANR_at_tusc.com>
Date: Thu, 9 Dec 2004 10:06:42 -0600
Message-ID: <F5E885BEF9540D47A7BDC03CF16880870A7D53B4@tuscil_ex1>

Good thoughts...

-----Original Message-----
From: Wolfgang Breitling
To: Freeman Robert - IL
Cc: oracle-l_at_freelists.org
Sent: 12/9/2004 9:26 AM
Subject: Re: Portable DBA: Oracle

Freeman Robert - IL wrote:
> Thanks Dwayne! Hope you like it!
>
> It's funny.... after I finally get a copy of a new book in my hands, I
> always see something I missed. For example, it just irks me that in my
> example of the use of dbms_stats.gather_table_stats that I don't
include
> cascade=>TRUE in the example.
>

Don't feel too bad about this one. IMHO, cascade=>FALSE (the default) is

the right choice, especially if you use estimate_percent of less than 100%. Then follow with an explicit gather_index_stats with a full compute. And any histograms also with a full compute.

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 09 2004 - 10:02:22 CST