<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
We are using External Tables to load CSV files to Oracle Database &nbsp;(Oracle 11gR2) on Windows 2008 R2. However, while average load time was 15-20 seconds previously, nowadays it takes even up to 15-20 minutes. The average size of CSV files did not change. <br />
<br />
What can be the problem or what can I do to trace the problem? <br />
<br />
BR
</div>
</div>


Dear Experts,

We are using External Tables to load CSV files to Oracle Database  (Oracle 11gR2) on Windows 2008 R2. However, while average load time was 15-20 seconds previously, nowadays it takes even up to 15-20 minutes. The average size of CSV files did not change. 

What can be the problem or what can I do to trace the problem? 

BR

External Table Load Very Slow

The Microsoft Legacy Operating System topic includes legacy versions of Microsoft operating systems prior to Windows 2000: All versions of MS-DOS and other versions developed for specific manufacturers and Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions, and Windows Mobile.

Microsoft Legacy OS

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.