Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

DBMS_XMLPARSER memory problems in 11.2 since 11.2.0.1

Mark S NHSApr 11 2018 — edited Apr 12 2018

I have upgraded our test database from 11.2.0.1 to 11.2.0.4 and am now getting intermittent memory related faults when I run p/sql code to "unpack" a parsed xml document (dbms_xmlparser - where the dbms_xslprocessor.valueOf(inMSH,'MSH.1/text()',l_fieldsep); command intermittently returns a null value.

The problem still exists even after I have increased the java_pool_size parametres from 0 to 1G although the increase has reduced the fault substantially.

Has anyone else experienced similar memory related problems with the use of DOM xml handling in releases of oracle 11g since 11.2.0.1?

What steps did you take to address the problem?

I have attached snippets of the pl/sql code I am using.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 10 2018
Added on Apr 11 2018
7 comments
937 views