Re: "control file sequential read" on RAC

  • From: "Shivaswamy Raghunath" <shivaswamykr@xxxxxxxxx>
  • To: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
  • Date: Tue, 15 May 2007 10:51:18 -0400

Fixed table stats are collected.

On 5/15/07, Alexander Fatkulin <afatkulin@xxxxxxxxx> 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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2007