Performance issue on XMLTABLE

Hi all, I've been detecting a particular query running into very long run time in one of my production database. My db version is Oracle 19c (19.12.0.0.0) .

I've raise this to my application team and they've bring this up to the application vendor since this is a new module for the application.

In the meantime I was trying to check if there's anything abnormal from DB standpoint. However when I pull the explain plan there's nothing much for me to see.

--------------------------------------------------------------------------------
| Id | Operation        | Name | Rows | Bytes | Cost (%CPU)| Time   |
--------------------------------------------------------------------------------
|  0 | SELECT STATEMENT    |   |    |    |  478K(100)|     |
|  1 | NESTED LOOPS OUTER   |   | 8168 |  264M|  478K (1)| 00:00:19 |
|  2 |  NESTED LOOPS OUTER  |   | 8168 |  133M|  239K (1)| 00:00:10 |
|  3 |  XMLTABLE EVALUATION |   |    |    |      |     |
|* 4 |  VIEW         |   |   1 | 17115 |  29  (0)| 00:00:01 |
|  5 |   XMLTABLE EVALUATION |   |    |    |      |     |
|* 6 |  VIEW         |   |   1 | 16826 |  29  (0)| 00:00:01 |
|  7 |  XMLTABLE EVALUATION |   |    |    |      |     |
--------------------------------------------------------------------------------