Re: Dbms_stats Analyze Data Dictionay ?

> However, there is no statistics on X$ tables. Neither
> dbms_stats.gather_table_stats, nor sampling works with X$ tables in 9.2.
> Therefore, any query against dictionary view having X$ tables in view
> definition might have a goofy plan generated.

But X$ "tables" aren't part of the Data Dictionary. Rather, they are gateways into memory locations, etc. There are no indexes on X$ tables, etc. So what relevance does this really have when talking about stats against the Data Dictionary?

Cheers,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam" from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"