dbms_stats.gather_fixed_objects_stats() fails on 11g Release 2(11.2.0.1.0). The bug is witnessed on Standard Edition databases, but should also apply to Enterprise Edition software, per my speculation.
Upon issuing the command, an error is returned:
SQL*Plus: Release 11.2.0.1.0 Production on Wed May 12 16:49:23 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.1.0 – 64bit Production
SQL> exec dbms_stats.gather_fixed_objects_stats;
BEGIN dbms_stats.gather_fixed_objects_stats; END;
*
ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-00439: feature not enabled: Data Guard
Broker
ORA-06512: at “SYS.DBMS_STATS”, line 20508
ORA-06512: at “SYS.DBMS_STATS”, line 20951
ORA-06512: at “SYS.DBMS_STATS”, line 21498
ORA-06512: at line 1
These bugs are involved:
Bug 9180311: GETTING ORA-20011 AND ORA-439 EXECUTING GATHER_FIXED_OBJECTS_STATS
Bug 9056912: GATHERING STATISTICS ON EXTERNAL TABLES REQUIRES NULL FOR ESTIMATE_PERCENT
Patch 9056912 is available for our platform(x86-64). And once applied, the problem is fixed. Note that there are post installation tasks to be carried out.
