O'Reilly logo

Oracle Data Integrator 11g Cookbook by Peter C. Boyd-Bowman, Denis Gray, Christophe Dupupet, Julien Testut

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Processing XML data within an RDBMS not in memory

By default, ODI will perform XML processing within the default in-memory database, HSQL. For out of the box JVM settings, small XML files, less than 2-3 megabytes, the in-memory database will perform as expected. However, for larger XML files, or when there is a large amount of files, it is easy to exceed the reserved amount of memory for processing within the JVM. When the JVM memory size is exceeded, the JVM will crash, and it is necessary to tune the JVM settings to allow for the large amount of memory the in-memory database will require. The XML JDBC Driver can also be set up to use a relational database for this processing. Similar to the in-memory database, a relational schema will be created ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required