Configuring the Oracle data cache for a bulk load (Oracle connector)

When bulk loading data into tables that contain DATE or TIMESTAMP columns, configuring the Oracle date cache might improve load performance.

About this task

If the date cache is enabled, the connector logs date cache usage statistics when the bulk load completes. You can use the statistics to determine whether changing the date cache size might improve the future load performance of similar input data sets. The connector logs these statistics:

Size of cache.
Number of elements that are stored in the cache.
Total number of hits, which occur when matches are found in the cache.
Total number of misses, which occur when matches are not found in the cache. Note that the connector does not count the misses until the cache is full.
Information about whether the cache was disabled during the bulk load.

Procedure

To configure the date cache:

Set Use Oracle date cache to Yes.
In the Cache size property, enter the maximum number of entries that the cache stores. The default is 1,000.
Set Disable cache when full to Yes. When the number of entries in the cache reaches the number specified in the Cache size property and the next lookup in the cache results in a miss, the cache is disabled.

Configuring the Oracle date cache for a bulk load