RE: Portable DBA: Oracle
- From: "Hollis, Les" <Les.Hollis@xxxxxx>
- To: <GJohnson@xxxxxxx>, <Rich.Jesse@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Dec 2004 10:59:41 -0600
Yeah what he said.... 8~))
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Johnson, George
Sent: Thursday, December 09, 2004 10:29 AM
To: 'Rich.Jesse@xxxxxxxxxxxxxxxxx'; oracle-l@xxxxxxxxxxxxx
Subject: 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. =20
Gj
-----Original Message-----
From: Jesse, Rich [mailto:Rich.Jesse@xxxxxxxxxxxxxxxxx]=20
Sent: 09 Dec 2004 15:44
To: oracle-l@xxxxxxxxxxxxx
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=20
> include cascade=3D>TRUE in the example.
>
Don't feel too bad about this one. IMHO, cascade=3D>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
--
//www.freelists.org/webpage/oracle-l
************************************************************************
****
This message contains confidential information and is intended only=20
for the individual or entity named. If you are not the named addressee
you should not disseminate, distribute or copy this e-mail. =20
Please notify the sender immediately by e-mail if you have received=20
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=20
message which arise as a result of e-mail transmission. =20
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=20
regulated or licensed in those jurisdictions as required.
************************************************************************
****
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
