ORA-600 [17147] during gathering table statistics with BMS_STATS.auto_degree

SQL> begin
  2        DBMS_STATS.gather_table_stats
  3                             (ownname =>               'DS_APP',
  4                              tabname =>               'TD_ITEM_INV',
  5                              estimate_percent =>      DBMS_STATS.auto_sample_size,
  6                              method_opt =>            'FOR ALL INDEXED COLUMNS SIZE AUTO',
  7                              CASCADE =>               TRUE,
  8                              DEGREE =>               
DBMS_STATS.auto_degree  9                             );
10  end;
11  /
begin
*
ERROR at line 1:
ORA-20011: Approximate NDV failed: ORA-12801: error signaled in parallel queryserver P008
ORA-00600: internal error code, arguments: [17147], [0x085241FA8], [], [], [],
[], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 23112
ORA-06512: at "SYS.DBMS_STATS", line 23205
ORA-06512: at line 2


This is an Oracle bug on Linux with 11.2.   A workarround is to change DEGREE = 1 or apply Patch #10013177

No comments:

Post a Comment