RE: Portable DBA: Oracle

        Analyze estimate with anything over 49% results in automatic compute. DBMS_STATS estimate option, will estimate to the percentage you request.

        Gj

-----Original Message-----
From: Jesse, Rich [mailto:Rich.Jesse_at_quadtechworld.com] Sent: 09 Dec 2004 15:44
To: oracle-l_at_freelists.org
Subject: RE: Portable DBA: Oracle

Without looking, doesn't estimate_percent >50 cause a compute? I remember it did on ANALYZE, but I don't remember with DBMS_STATS... Rich

-----Original Message-----
Sent: Thursday, December 09, 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



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


****************************************************************************
This message contains confidential information and is intended only 
for the individual or entity named.  If you are not the named addressee
you should not disseminate, distribute or copy this e-mail.  
Please notify the sender immediately by e-mail if you have received 
this e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed, arrive
late or incomplete, or contain viruses.  The sender therefore does not
accept liability for any errors or omissions in the contents of this 
message which arise as a result of e-mail transmission.  
If verification is required please request a hard-copy version.
This message is provided for informational purposes and should not
be construed as an invitation or offer to buy or sell any securities or
related financial instruments.
GAM operates in many jurisdictions and is 
regulated or licensed in those jurisdictions as required.
****************************************************************************

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