1.52 DICTIONARY_CACHE_SIZE

Valid For

Valid for Extract.

Description

The dictionary_cache_size (default 5000) parameter sets the LogMiner dictionary cache size.

The cache size can become a limiting factor during heavy DDL workloads causing LogMiner builder to become CPU-bound and messages in trace file indicating dictionary objects being reloaded.

This example explains such a situation:

krvrdgcidi_GetChunkIdInt: loaded obj 137584, scn 0x000000001f65a041, beg scn 0x000000001c16a034, end scn 0xffffffffffffffff, tsn 6, SOESMALLTS, chunk 0