版本:11.2.0.3.0 AIX 6.1
在执行exec dbms_sqltune.accept_sql_profile(task_name=>'tc',replace=>true,profile_type=>dbms_sqltune.px_profile,force_match => TRUE);
或exec dbms_sqltune.accept_sql_profile(task_name=>'tc',replace=>true);
遇到:
ERROR at line 1: ORA-13786: missing SQL text of statement object "1" for tuning task "tc" ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 16442 ORA-06512: at "SYS.PRVT_SQLPROF_INFRA", line 31 ORA-06512: at "SYS.DBMS_SQLTUNE", line 7544 ORA-06512: at "SYS.DBMS_SQLTUNE", line 7568 ORA-06512: at line 1
查询为Bug 14666237
不仅11.1版本,11.2也仍然存在该Bug。