XDB.DBMS_XMLPARSER causing an application to hang (Doc ID 1103716.1)

Last updated on AUGUST 02, 2010

In this Document
  Symptoms
  Cause
  Solution
  References


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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms