Re: Analyze and 11g
- From: Gus Spier <gus.spier@xxxxxxxxx>
- To: Chris.Stephens@xxxxxxx
- Date: Tue, 23 Aug 2011 12:28:54 -0400
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@xxxxxxx>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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *P D
> *Sent:* Thursday, August 11, 2011 7:39 AM
> *To:* oracle-l@xxxxxxxxxxxxx
> *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.
>
>
>
Other related posts:
