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: query on ditionary objects

Re: query on ditionary objects

From: Radoulov, Dimitre <cichomitiko_at_gmail.com>
Date: Wed, 19 Oct 2005 11:03:46 +0200
Message-ID: <018f01c5d48c$048ebb20$1a03310a@IBME1D11967173>


And what about the argument GATHER_FIXED in the procedures GATHER_DATABASE_STATS/GATHER_SCHEMA_STATS ? Anybody tested/used it?

Cheers,
Dimitre

>> My guess would be oposite. According to Oracle Docs, you should not
>> collect stats for objects in SYS schema in 9i or the database will creep.
>
> It's supported in Oracle 9i(but normally not recommended:)).
>
> For more information MetaLink Note 245051.1:
>
> <quote>
> "Gathering statistics on the Data Dictionary in Oracle9i is a supported
> activity.
> If performance (or other) problems are detected following statistics
> gathering then these should be raised up with Oracle Support for
> resolution.
>
> In the majority of cases, gathering Data Dictionary statistics should not
> be necessary (and would not normally be recommended) since the dictionary
> has been optimized to cater for most common database setups.
> If, however, the performance of queries against the data dictionary
> becomes a issue (for example because the database is made up of an
> abnormally large number of application objects) then gathering dictionary
> statistics can be considered.
>
> Data Dictionary Statistics should only be gathered using the DBMS_STATS
> package.
> Typical commands for gathering and removing Data Dictionary statistics
> are:
> execute dbms_stats.gather_schema_stats('SYS');
>
> Data Dictionary statistics can be removed using:
> execute dbms_stats.delete_schema_stats('SYS');"
> </quote>
>
>
>
>
> Cheers,
> Dimitre Radoulov
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 19 2005 - 04:06:07 CDT

Original text of this message

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