4 Replies Latest reply: Aug 22, 2012 12:35 PM by Marco Gralike RSS

    XML performance issue in Oracle 8i

      I have implemeted the code as per the link http://www.oracle-base.com/articles/8i/parse-xml-documents-8i.php to convert & Load an XML Document to multiple tables in Oracle database. As the number of nodes increase in the xml file, the processing time of XML file is increasing exponentially.(For Example:- if there are more than 500 Employee-Dept details in an XML file, parsing of XML file is taking about 5 hours ) Could anyone let me know what changes can be done inorder to reduce the parsing time.