there is nothing in the alert log,udump, or cdump on this. Im going to have them run the package with a 10046 trace next. would a different trace be more appropriate? > > From: <[EMAIL PROTECTED]> > Date: 2003/09/30 Tue PM 02:24:30 EDT > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Subject: problem with xmlparser and dom objects > > I didnt write this code and am not particularly familiar with this part of Oracle. > We are attempting to migrate some CLOB data. To do this we batch load it into DOM > objects, then user XMLPARSER to parse it, then do an insert. > > We are finding that it sucks up so many resources that you cant even log in. This is > in an 8i database and the only way to get in is through SVRMGRL and all I can do is > a shutdown abort. > > any idea what to look for in this code? Im not very familiar with ORACLE Java? The > code was written before I got here and by someone who is no longer with the company. > Ive read a little on Oracle Java and I know Java somewhat. > > I first thought we were in archive log mode and the archiver could not keep up. We > are not. Now I think it may be that the DOM object memory does not get deallocated > and when Oracle tries to allocate more memory the system just hangs. I know when you > use SQL or PL/SQL and run out of PGA memory the query crashes or Oracle swaps to > temp space. > > anyone have experience with this? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). >
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).