Fixed table stats are collected.
On 5/15/07, Alexander Fatkulin <afatkulin_at_gmail.com> wrote:
>
> Have you collected stats on the fixed objects?
>
> dbms_stats.gather_fixed_objects_stats
>
> >I found that, x$kccfe which is used in the defenition of
> dba_data_files (Now in 10.2 to give the >ONLINE_STATUS Of the data
> file) is causing the issue. But I have not yet gone in to the root
> >cause.
> >
> > Meanwhile, if you have more insight do let me know.
> >
> >
>
>
> --
> Alexander Fatkulin
>
--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 15 2007 - 09:51:18 CDT
