Database Tuning (MOSC)

MOSC Banner

dbms_sqltune.accept_sql_profile fails with ORA-31011: XML parsing failed

edited May 16, 2019 8:09PM in Database Tuning (MOSC) 3 commentsAnswered

SQL> execute dbms_sqltune.accept_sql_profile(task_name => 'TASK_49818', task_owner => 'SYS', replace => TRUE);

BEGIN dbms_sqltune.accept_sql_profile(task_name => 'TASK_49818', task_owner => 'SYS', replace => TRUE); END;

*

ERROR at line 1:

ORA-31011: XML parsing failed

ORA-19213: error occurred in XML processing at lines 1

LPX-00240: element-start tag is not well formed

ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 17803

ORA-06512: at "SYS.PRVT_SQLPROF_INFRA", line 31

ORA-06512: at "SYS.DBMS_SQLTUNE", line 8680

ORA-06512: at "SYS.DBMS_SQLTUNE", line 8704

ORA-06512: at line 1

Message was edited by: User13351016-Oracle

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center