My Oracle Support Banner

DBMS_SPM.drop_sql_plan_baseline/Perfstat.statspack.snap fails with Error ORA-31011 ORA-19213 LPX-00210 (Doc ID 2658414.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Drop SQL PLAN BASELINE Fails with Error Message : ORA-31011: XML parsing failed

set serveroutput on
declare
 l_plans_dropped  pls_integer;
begin
 l_plans_dropped := dbms_spm.drop_sql_plan_baseline (sql_handle => 'SQL_99088fd566e3d72ff');
 dbms_output.put_line(l_plans_dropped);
end;
/
SQL>   2    3    4    5    6    7  declare
*
ERROR at line 1:
ORA-31011: XML parsing failed
ORA-19213: error occurred in XML processing at lines 1
LPX-00210: expected '<' instead of 'â–’'
ORA-06512: at "SYS.DBMS_SPM", line 1654
ORA-06512: at line 4

STATSPACK Gathering Fails with Error Message : ORA-31011: XML parsing failed

BEGIN perfstat.statspack.snap(i_snap_level=>6); END;

*
ERROR at line 1:
ORA-31011: XML parsing failed
ORA-19213: error occurred in XML processing at lines 1
LPX-00210: expected '<' instead of '¿'
ORA-06512: at "PERFSTAT.STATSPACK", line 4757
ORA-06512: at "PERFSTAT.STATSPACK", line 5730
ORA-06512: at "PERFSTAT.STATSPACK", line 105
ORA-06512: at line 1

 

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


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