1、环境
Oracle 10.2.0.5 RAC,AIX系统
2、Oracle统计信息收集,报错:
SQL> BEGIN dbms_stats.gather_table_stats(ownname =>'A_DTB1',tabname =>'TS_ADT_01',degree=>16,cascade => true,estimate_percen
t=>dbms_stats.auto_sample_size); END;
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_STATS", line 15027
ORA-06512: at "SYS.DBMS_STATS", line 15049
ORA-06512: at line 1
3、解决办法
--加了 GRANULARITY=>'ALL '
exec dbms_stats.gather_table_stats(ownname=>' A_DTB1', tabname=>' TS_ADT_01', degree=>16, cascade=>true,
estimate_percent=>dbms_stats.auto_sa
Oracle 10.2.0.5 RAC,AIX系统
2、Oracle统计信息收集,报错:
SQL> BEGIN dbms_stats.gather_table_stats(ownname =>'A_DTB1',tabname =>'TS_ADT_01',degree=>16,cascade => true,estimate_percen
t=>dbms_stats.auto_sample_size); END;
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_STATS", line 15027
ORA-06512: at "SYS.DBMS_STATS", line 15049
ORA-06512: at line 1
3、解决办法
--加了 GRANULARITY=>'ALL '
exec dbms_stats.gather_table_stats(ownname=>' A_DTB1', tabname=>' TS_ADT_01', degree=>16, cascade=>true,
estimate_percent=>dbms_stats.auto_sa