OraFAQ Forum: JDeveloper, Java & XML » XML Parsing - Out of memory error and Process slow down

Home » Developer & Programmer » JDeveloper, Java & XML » XML Parsing - Out of memory error and Process slow down

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

XML Parsing - Out of memory error and Process slow down [message #176499]

Thu, 08 June 2006 09:29

kusuma
Messages: 5
Registered: December 2000
Location: India

Junior Member

Hi,

My procedure parses XML documents and places the values obtained through it into 5 tables. The XML documents are stored in a table as clob data type. The table which has the XMLs contains around 1000 records( the number might increase in the future). The procedure is running well for the first 100 records taking on an average around 0.4 minutes to parse each XML. After the first 100 XMLs are parsed, the time being taken to parse each XML is increasing exponentially. For the 180th XML it is taking around 14minutes to parse. When the 205th XML is reached, the error

"ORA-04030: out of process memory when trying to allocate 4000 bytes (qmxlu subheap,qmemNextBuf:alloc)
ORA-06512: at "XDB.DBMS_XSLPROCESSOR", line 685
ORA-06512: at "XDB.DBMS_XSLPROCESSOR", line 719"

is being raised and the execution is getting terminated.

The Oracle version that i am using is 9.2.0.6.0

Please help on this.

Thanks in advance.
Kusuma.

Report message to a moderator

Previous Topic:	JDeveloper 10g(10.1.3)- How to do custom mapping from java to XML and vice versa??
Next Topic:	Read Unicode chars and insert into Oracle DB

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 05:34:41 CST 2024