Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Dbms_stats giving OA-06512 error

Dbms_stats giving OA-06512 error

From: William Wagman <wjwagman_at_ucdavis.edu>
Date: Fri, 5 Jan 2007 11:12:50 -0800
Message-ID: <FE043305B38A0F448F3924429D650C2AD365E5@VEXBE2.ex.ad3.ucdavis.edu>


Greetings,

I have been running dbms_stats.gather_schema_stats against test/development database for some time and recently added

estimate_percent => dbms_stats.auto_sample_size

Since which time ORA-06152 errora are generated...

BEGIN dbms_stats.gather_schema_stats( ownname => 'EDRS', estimate_percent => dbms_stats.auto_sample_size, method_opt => 'for all columns', cascade => true, options => 'GATHER', degree => 15); END;

*
ERROR at line 1:

ORA-00979: not a GROUP BY expression
ORA-06512: at "SYS.DBMS_STATS", line 10502
ORA-06512: at "SYS.DBMS_STATS", line 10996
ORA-06512: at "SYS.DBMS_STATS", line 11183
ORA-06512: at "SYS.DBMS_STATS", line 11237
ORA-06512: at "SYS.DBMS_STATS", line 11214
ORA-06512: at line 1

I suspect it has to do with dbms_stats not knowing how to deal with the stats which have already been collected but that is just a guess. I am not familiar enough with views such as DBA_TAB_MODIFICATIONS to know if information stored there is causing the problems or if deleting and regenerating statistics (I haven't tried that yet) will solve the problem. I would appreciate any insight into the problem.

Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 05 2007 - 13:12:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US