Re: Analyze and 11g

From: Gus Spier <gus.spier_at_gmail.com>
Date: Tue, 23 Aug 2011 12:28:54 -0400
Message-ID: <CAG8xnid_D0=Ek4UXD0x9=Gvg8Ra7wCpOnw=h9FmjOEoPHzbizQ_at_mail.gmail.com>

Mladen has taken up new residence in comp.databases.oracle.server .. I get the impression he became disenchanted with oracle-L.

Just as brilliant as ever he was, though.

Friendly regards,
Gus

On Tue, Aug 23, 2011 at 11:59 AM, Stephens, Chris <Chris.Stephens_at_adm.com>wrote:

> That is a very odd question to ask. Use for what? If to gather database
> statistics (for the entire database in one go) then yes, I still use
> dbms_stats.gather_database_stats. ****
>
> ** **
>
> There are many potential drawbacks, at least one for each piece of SQL
> executed in the database.****
>
> ** **
>
> Whatever happened to Mladen Golgala? (sp?)****
>
> ** **
>
> Chris****
>
> ** **
>
> ** **
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *P D
> *Sent:* Thursday, August 11, 2011 7:39 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* Analyze and 11g****
>
> ** **
>
> Does anybody still run dbms_stats.gather_database_stats in 11g (11.1.0.7 to
> be specfic)? Is there any drawback from doing so? ****
>
> CONFIDENTIALITY NOTICE:
> This message is intended for the use of the individual or entity to which
> it is addressed and may contain information that is privileged, confidential
> and exempt from disclosure under applicable law. If the reader of this
> message is not the intended recipient or the employee or agent responsible
> for delivering this message to the intended recipient, you are hereby
> notified that any dissemination, distribution or copying of this
> communication is strictly prohibited. If you have received this
> communication in error, please notify us immediately by email reply.
>
>
>

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

Received on Tue Aug 23 2011 - 11:28:54 CDT