File Processing – Performance Fix 12c

Problem Statement

Post Oracle Fusion upgrade from 11g to 12c, there is slowness during file processing via file transport.

Solution

A quick win solution to change the XQuery version from 2004 to 1.0 helps you achieve your target partially.

Changes required in XQuery:

Existing XQuery in 11g starts with:

xquery version “2004-draft“;

Modified XQuery (Need of an Hour):

xquery version “1.0“;

NOTE: Do not forget to performance test your modified code.

Benefits

1. Reduces 20% of processing time of files
2. Performance improvement
3. With huge files, the performance may be better