Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_lob.createtemporary memory leak even with dbms_lob.freetemporary

698658Mar 25 2010 — edited Mar 25 2010
I've got procedure which basicaly transforms one xml structure into other xml structure and then inserts that other into clob column.
I'm using xmlParser.parser , xmlDom.DomDocument .
After every iterations of procedure my PGA grows .
I'm using xmldom.freeDocument(doc) xmldom.freeDocument(document) xmlparser.freeparser(parser) and dbms_lob.freetemporary .
So have no idea what could cause the memory leak .
Is DBMS_LOB.CALL duratino solution to my problem ?
Default is session long DBMS_LOB.SESSION .


wynik        CLOB;
  v_xc         CLOB;
  doc          xmldom.DOMDocument
 
BEGIN
 
    dbms_lob.createtemporary(wynik,true);
    INSERT INTO tabxml   
      (id_xml, dane)
    VALUES
      (XML_ID, empty_clob())
    RETURNING dane into v_xc;
    xmldom.writeToClob(doc, wynik);
    dbms_lob.copy(v_xc,wynik, dbms_lob.getlength(wynik));
   dbms_lob.freetemporary(wynik);
END;
DB 9.2.0.8
Regards.
Greg
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2010
Added on Mar 25 2010
1 comment
919 views