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