Re: "control file sequential read" on RAC
- From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- To: shivaswamykr@xxxxxxxxx
- Date: Wed, 16 May 2007 01:46:29 +1100
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
