XDB.DBMS_XMLPARSER causing an application to hang
(Doc ID 1103716.1)
Last updated on FEBRUARY 21, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 to 220.127.116.11 [Release 10.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Session running an application which calls XDB.DBMS_XMLPARSER hangs. Memory usage is stable, but CPU usage is increasing. The only way to stop the session is by killing it.
The application is calling DBMS_XMLPARSER.freeparser (<variable>) in a loop as it parses multiple files.
Error stack generated by oradebug dump errorstack 3 or by OS functions like procstack (AIX) or pstack (Solaris/Linux) shows
ksdxfdmp ksdxcb sspuser _restore_rt qmpa_parser_freeparser spefcmpa spefmccallstd
0x0000000100963d50 qmubaGet(??, ??, ??) + 0x30
0x0000000108342494 qmpa_parser_freeparser(0x0, 0x110a719a0,0xfffffffffff5198,0x110920118) + 0x114
0x0000000102e84334 spefcmpa(??, ??, ??, ??, ??) + 0x134
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