ORA-13768 & ORA-01422 Errors on Performing SPM Evolve Tasks
(Doc ID 2507958.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
- Creating an evolve task and trying to execute the evolve task from cloned database, receives different errors on the execute evolve task:
- SQL> SET SERVEROUTPUT ON
SET TIMING ON
DECLARE
l_return VARCHAR2(32767);
BEGIN
l_return := DBMS_SPM.execute_evolve_task(task_name => 'XYZ');
DBMS_OUTPUT.put_line('Execution Name: ' || l_return);
END;
/SQL> SQL> 2 3 4 5 6 7
DECLARE
*
ERROR at line 1:
ORA-13768: Snapshot ID must be between 170 and 176.
ORA-06512: at "SYS.DBMS_SPM_INTERNAL", line 3770
ORA-06512: at "SYS.DBMS_SPM_INTERNAL", line 4771
ORA-06512: at "SYS.DBMS_SQLTUNE", line 8422
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_SQLTUNE_UTIL2", line 104
ORA-06512: at "SYS.DBMS_SQLTUNE", line 5056
ORA-06512: at "SYS.DBMS_SQLTUNE", line 8342
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SPM_INTERNAL", line 4566
ORA-06512: at "SYS.DBMS_SPM_INTERNAL", line 3736
ORA-06512: at "SYS.PRVT_ADVISOR", line 3333
ORA-06512: at "SYS.PRVT_ADVISOR", line 756
ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 13887
ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 13907
ORA-06512: at "SYS.WRI$_ADV_SPM_EVOLVE", line 7
ORA-06512: at "SYS.PRVT_ADVISOR", line 739
ORA-06512: at "SYS.PRVT_ADVISOR", line 3238
ORA-06512: at "SYS.DBMS_ADVISOR", line 262
ORA-06512: at "SYS.DBMS_SPM", line 2695
ORA-06512: at line 4Elapsed: 00:00:15.38
DECLARE
l_return VARCHAR2(32767);
BEGIN
l_return := DBMS_SPM.execute_evolve_task(task_name => 'XYZ1');
DBMS_OUTPUT.put_line('Execution Name: ' || l_return);
END;
/SQL> SQL> 2 3 4 5 6 7
DECLARE
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "SYS.DBMS_SPM_INTERNAL", line 3770
ORA-06512: at "SYS.DBMS_SPM_INTERNAL", line 3654
ORA-06512: at "SYS.PRVT_ADVISOR", line 3333
ORA-06512: at "SYS.PRVT_ADVISOR", line 756
ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 13887
ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 13907
ORA-06512: at "SYS.WRI$_ADV_SPM_EVOLVE", line 7
ORA-06512: at "SYS.PRVT_ADVISOR", line 739
ORA-06512: at "SYS.PRVT_ADVISOR", line 3238
ORA-06512: at "SYS.DBMS_ADVISOR", line 262
ORA-06512: at "SYS.DBMS_SPM", line 2695
ORA-06512: at line 4
- SQL> SET SERVEROUTPUT ON
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 |
Cause |
Solution |