The performance difference between the direct loading mode and the traditional loading mode of Sql*loader

1. Confirm the database version

2. Data Preparation

3. Create import tables and control files

4. Direct Load Mode demo

To view a specific log:

5. Traditional Load Mode demo

To view the log file:

6. Conclusions and differences between the two ways

The conventional is 10 times times more efficient than the direct ratio.

Compare the differences between the two modes of loading:

• Direct Features

ü Data bypasses the SGA directly to the disk's data file.

ü The data is written directly to the new block after the high watermark HWM, and the free blocks before the HWM are not scanned.

Ücommit then move HWM others to see.

ü Do not scan the used space.

ü The use of direct does not produce redo log at all, not completely (poor security), but will produce undo data.

ü OLAP on-line analysis of the scene, delete and change the scene is not frequent.

• Conventional traditional loading features

ü Data is loaded with the data file of the SGA----disk first.

U will scan the data block before the high watermark HWM, if there are free blocks (fragmentation is often caused by DML) will be exploited if no new blocks are inserted.

ü The data block before the high watermark HWM is placed in the SGA area.

u will generate redo log and undo data.

ü High security, recoverable data.

ü Traditional loading is no different from SQL statement insert insertion.

Sql*loader the direct load mode and the traditional load mode performance difference