-
Hello DBAs !!!
Since few days, Statistics don't work correctly in my dev server. When i look the stats log file on morning, I see this error :
------------------------------------------------------------------
BEGIN dbms_utility.analyze_SCHEMA('SCHEMA1','COMPUTE',NULL,NULL,'FOR ALL COLUMNS'); END;
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [16515], [D], [40], [7202], [4], [0], [], []
ORA-06512: at "SYS.DBMS_DDL", line 179
ORA-06512: at "SYS.DBMS_UTILITY", line 331
ORA-06512: at line 1
------------------------------------------------------------------
I don't know why this error occurs.
Can anyone help me or give me some idea ?
Thx
-
What do you have in your init.ora parameters:
optimizer_features_enable and compatible?
Have you tried to delete statistics and run again?
There are a lot of information in metalink about this error.
All in metalink point to delete statistics and run again
Regards
Angel
-
Run first
Code:
alter session set "_enable_type_dep_selectivity" = true;
and then
Code:
BEGIN dbms_utility.analyze_SCHEMA('SCHEMA1','COMPUTE',NULL,NULL,'FOR ALL COLUMNS'); END;
If that doesn't help, delete the statistics and try again, if that doesn't help, open an iTart with Metalink.
Do you get the arror if you analyze table by table, i.e.,
Code:
analyze table TABLE_NAME compute statistics;
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Julian,
What do exactly the parameter _enable_type_dep_selectivity?
Thanks
Angel
-
Thx a lot
I will try as soon as possible.
But how can i delete statistics ?
-------------------------------
Sorry but i'm a junior DBA
-------------------------------
-
BEGIN
dbms_utility.analyze_schema('SCHEMA','DELETE',NULL,NULL,'FOR ALL COLUMNS');
END;
/
Regards
Angel
-
Originally posted by aarroyob
Julian,
What do exactly the parameter _enable_type_dep_selectivity?
Thanks
Angel
It is an anti-bug parameter that might help avoiding the 600-error when collecting statistics. Might help, might not.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Thx a lot !!!!
I will try all your solutions.
-
Thanks as always for share your knowledge with us Julian
Cheers
Angel
-
For information :
Delete statistics don't work.
I'll try in few days to set the parameter enable_type_dep_selective in the init.ora when I could restart the DB.
Thx
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|