Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Mailing Lists -> Oracle-L -> Re: What are the implications of running dbms_stats and analyze compute?

Re: What are the implications of running dbms_stats and analyze compute?

From: Peter Sylvester <peters_at_mitre.org>
Date: Tue, 09 Aug 2005 12:04:23 -0400
Message-ID: <42F8D407.3000700@mitre.org>

It seems to me that using dbms_stats.gather_schema_stats will blow away any previous stats collected on the account (either via dbms_stats or analyze).
I'd be inclined to test it out to be sure.

--Peter

--

http://www.freelists.org/webpage/oracle-l Received on Tue Aug 09 2005 - 11:08:49 CDT

This message: [ Message body ]
Next message: mkb: "Re: Disk solution for the small Oracle shop....shared disk space options for Linux servers???"
Previous message: Ana Choto: "Re: What are the implications of running dbms_stats and analyze compute?"
Maybe in reply to: Ana Choto: "What are the implications of running dbms_stats and analyze compute?"
Next in thread: Allen, Brandon: "RE: What are the implications of running dbms_stats and analyze compute?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US