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 11.2.0.1 [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.
Symptoms
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
or
0x0000000100963d50 qmubaGet(??, ??, ??) + 0x30
0x0000000108342494 qmpa_parser_freeparser(0x0, 0x110a719a0,0xfffffffffff5198,0x110920118) + 0x114
0x0000000102e84334 spefcmpa(??, ??, ??, ??, ??) + 0x134
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 |
References |