[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

ORA-29554: unhandled Java out of memory condition

Posted on 2003-03-06
3
Medium Priority
?
1,364 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
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
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
Course of the Month11 days, 12 hours left to enroll

640 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