problem with xmlparser and dom objects

From: <rgaffuri_at_cox.net>
Date: Tue, 30 Sep 2003 10:24:30 -0800
Message-ID: <F001.005D1866.20030930102430@fatcity.com>

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: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

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: ListGuru_at_fatcity.com (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). Received on Tue Sep 30 2003 - 13:24:30 CDT