ORA-13768 & ORA-01422 Errors on Performing SPM Evolve Tasks (Doc ID 2507958.1)

Last updated on JULY 20, 2024

Applies to:

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 4

    Elapsed: 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

   

   

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.