My Oracle Support Banner

Export or Import of Table with LOB Columns (like CLOB and BLOB) has Slow Performance (Doc ID 281461.1)

Last updated on FEBRUARY 11, 2021

Applies to:

Oracle Database - Personal Edition - Version to [Release 8.1.7 to 11.2]
Oracle Database - Enterprise Edition - Version to [Release 8.1.7 to 11.2]
Oracle Database - Standard Edition - Version to [Release 8.1.7 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


An export or import of a table with a Large Object (LOB) column, has slower performance than an export or import of a table without LOB columns.

Tests done with table with CLOB and without CLOB. Both tables contained 500,000 rows of data.

                                       No CLOB      No CLOB           With CLOB
                                        DIRECT CONVENTIONAL         column
----------------------------------------------------------------------------------------                                0:13               0:20                      7:49                                0:14               0:18                      7:37                                0:12               0:15                      7:03                              0:16               0:31                      7:15                              1:36               2:13                      7:55                              0:20               0:10                      2:46                              1:54               2:03                    24:43

Above performance results should not be considered as a benchmark of the performance between different Oracle versions, as the test databases were located on different machines with different hardware, and the databases had a different parameter configuration. The main objective of these results is to give an indication of the difference in the time that is needed to export a table with a LOB column, and a table without a LOB column.



You recently created tables that have Large Object (LOB) columns.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.