Unoptimized XML Construct Detected (Doc ID 3054412.1)

Last updated on OCTOBER 18, 2024

Applies to:

Symptoms

Unoptimized XML construct detected (enable XMLOptimizationCheck for more information)

Recently upgraded the database from 12c to 19.20 DBRU. Explain plan of the sql statement same is not seen in 12c.

PLAN_TABLE_OUTPUT

Plan hash value: 3234751492

--------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 406G| 1124T| 1450M (7)| 15:44:04 |
| 1 | NESTED LOOPS OUTER | | 406G| 1124T| 1450M (7)| 15:44:04 |
| 2 | NESTED LOOPS OUTER | | 49M| 115G| 182K (1)| 00:00:08 |
| 3 | MERGE JOIN OUTER | | 6100 | 14M| 16607 (1)| 00:00:01 |
|* 4 | TABLE ACCESS BY INDEX ROWID BATCHED| EDI_INLOADXML_INFO | 6100 | 13M| 4406 (1)| 00:00:01 |
|* 5 | INDEX RANGE SCAN | IDX_EDI_INLOADXML_INF_UK1 | 6194 | | 45 (0)| 00:00:01 |
| 6 | BUFFER SORT | | 1 | 158 | 12202 (1)| 00:00:01 |
| 7 | VIEW | | 1 | 158 | 2 (0)| 00:00:01 |
|* 8 | FILTER | | | | | |
| 9 | FAST DUAL | | 1 | | 2 (0)| 00:00:01 |
| 10 | XPATH EVALUATION | | | | | |
| 11 | XMLTABLE EVALUATION | | | | | |
| 12 | SORT AGGREGATE | | 1 | 4 | | |
|* 13 | XPATH EVALUATION | | | | | |
--------------------------------------------------------------------------------------------------------------------

Cause

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