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.