Gather Statistics Failed Out With ORA-00600 [qeaeMinmax: IV workarea len] Error
(Doc ID 2741195.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.4.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
- Gather statistics by DBMS_STATS with METHOD_OPT as the default of SIZE AUTO or SIZE 1 failed out with ORA-00600 [qeaeMinmax: IV workarea len] error:
SQL> execute DBMS_STATS.GATHER_TABLE_STATS( ownname => '<OWNER>',tabname => '<TABLE_NAME>', estimate_percent => 20, degree => 1, cascade => false);
BEGIN DBMS_STATS.GATHER_TABLE_STATS( ownname => '<OWNER>',tabname => '<TABLE_NAME>', estimate_percent => 20, degree => 1, cascade => false); END;
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [qeaeMinmax: IV workarea len],
[30001], [3], [5], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SQL", line 1735
ORA-06512: at "SYS.DBMS_STATS", line 30213
ORA-06512: at "SYS.DBMS_STATS", line 36821
ORA-06512: at "SYS.DBMS_STATS", line 38738
ORA-06512: at "SYS.DBMS_STATS", line 39738
ORA-06512: at "SYS.DBMS_STATS", line 40183
ORA-06512: at "SYS.DBMS_STATS", line 40732
ORA-06512: at line 1
SQL> execute DBMS_STATS.GATHER_TABLE_STATS( ownname => '<OWNER>',tabname => '<TABLE_NAME>',estimate_percent => 1,degree => 1,METHOD_OPT=>'FOR ALL COLUMNS SIZE 1', cascade => false);
BEGIN DBMS_STATS.GATHER_TABLE_STATS( ownname => '<OWNER>',tabname => '<TABLE_NAME>',estimate_percent => 1,degree => 1,METHOD_OPT=>'FOR ALL COLUMNS SIZE 1', cascade => false); END;
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [qeaeMinmax: IV workarea len],
[30001], [3], [5], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SQL", line 1735
ORA-06512: at "SYS.DBMS_STATS", line 30213
ORA-06512: at "SYS.DBMS_STATS", line 36821
ORA-06512: at "SYS.DBMS_STATS", line 38738
ORA-06512: at "SYS.DBMS_STATS", line 39738
ORA-06512: at "SYS.DBMS_STATS", line 40183
ORA-06512: at "SYS.DBMS_STATS", line 40732
ORA-06512: at line 1
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |