Re: Errors when running dbms_stats.gather_fixed_object_stats

From: Maureen English <>
Date: Tue, 25 Mar 2008 11:20:44 -0800
Message-ID: <>


I seem to have left out that I found the same information you refer to. My problem is that we are not using ASM. So, no, we're not running css, but I see no reason to be running it.

Did I miss something critical here? We installed in a new ORACLE_HOME, patched to, and definitely ran all of the root scripts after the installation. We've applied the cpuoct2007 and cpujan2008 patches, as well as 2 other recommended Oracle patches to fix problems we've encountered.

The gather_fixed_objects_stats procedure completes successfully:
> SQL> exec dbms_stats.gather_fixed_objects_stats;
> PL/SQL procedure successfully completed.
> SQL>

  • Maureen

Bobak, Mark wrote:
> "Rediscovery:
> When CSS/HAS is not installed and executed and v$asm_diskgroup
> or similar ASM queries are issued with excessive logs in trace
> files complaining about OCR not ready and/or CSS not running,
> customers then have the issue.
> Workaround:
> Run CSS"
> So, are you running CSS?
> Do:
> ps -ef|grep css
> Do you see css running? If not, why not? CSS is required, even for single-instance ASM. Did you run all the scripts at the appropriate times (and as root) during the installation?

Received on Tue Mar 25 2008 - 14:20:44 CDT

Original text of this message