ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 7093 ORA-06512: at "SYS.DBMS_SQLTUNE", line 5537 ORA-06512: at line 1

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:    ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 7093 ORA-06512: at "SYS.DBMS_SQLTUNE", line 5537 ORA-06512: at line 1

Symptoms:

Apply a SQL profile

Getting the following error
ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 7093 ORA-06512: at "SYS.DBMS_SQLTUNE", line 5537 ORA-06512: at line 1

SQL> exec dbms_sqltune.accept_sql_profile(task_name => 'xxims_sql', replace => TRUE); 
BEGIN dbms_sqltune.accept_sql_profile(task_name => 'xxims_sql', replace => TRUE); END;

*
ERROR at line 1:
ORA-13605: The specified task or object xxims_sql does not exist for the
current user.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.PRVT_ADVISOR", line 4744
ORA-06512: at "SYS.DBMS_SQLTUNE", line 5526
ORA-06512: at "SYS.DBMS_SQLTUNE", line 5564
ORA-06512: at line 1

Log files:

Solution:

BUG 5917151 : ORA-6502:PL/SQL: NUMERIC OR VALUE ERROR WHILE RUNNING IMPLEMENT_TUNING_TASK
BUG 5518876 : ORA-6502 ORA-6512 WHEN ACCEPTING SQL PROFILE

 Use the bellow note and try to create an SQL profile for the query that you want. Capture in a spool file all the steps that you will do and upload it to MOS:

Note.262687.1 Ext/Pub How to use the Sql Tuning Advisor.

References:

BUG 5917151 : ORA-6502:PL/SQL: NUMERIC OR VALUE ERROR WHILE RUNNING IMPLEMENT_TUNING_TASK
BUG 5518876 : ORA-6502 ORA-6512 WHEN ACCEPTING SQL PROFILE

Get Oracle Certifications for all Exams
Free Online Exams.com