?
Solved

ORA-29554: unhandled Java out of memory condition

Posted on 2003-03-06
3
Medium Priority
?
1,270 Views
Last Modified: 2007-11-27
hi all,

i'm getting the error

ORA-29554: unhandled Java out of memory condition

when trying to parse xml files into some oracle tables. my process calles several procedures and uses the oracle xml packages to parse and store data from the xml files in tables. i have been battling this issue for some time. please see theses links to find out more:

http://www.experts-exchange.com/Databases/Oracle/Q_20396280.html

http://www.experts-exchange.com/Databases/Oracle/Q_20457732.html

i believe i am freeing all xml components such as the processor and document. i have upped my java_max_sessionspace_size paramter to 200mb, the java_soft_sessionsapce_limit to 200mb, the java_pool_size to 200mb, and used the pl/sql procedure suggested by lucy in the second link above to increase the memory for my session to 200mb. some of the files i'm parsing are fairly large, but i just can't believe i'm using up this much memory. does anybody have any idea how i can get around this? thanks.

ben
0
Comment
Question by:benpung
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 1

Author Comment

by:benpung
ID: 8083880
is there a way to tell oracle to just ignore an error? i don't mean:

begin
stetements;
exception
when other then
null;
end;

i mean tell it to ignore the error and continue on with what it was doing.
0
 
LVL 1

Accepted Solution

by:
indypung earned 225 total points
ID: 8167974
using DOM to process xml is very memory intensive. need to look in to using SAX.
0
 

Expert Comment

by:suniljamini
ID: 12216119
Ora-29554 might come due to less "java_max_sessionspace"

Please try increasing it and refer following notes for more info:
Sunil Jamini
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question