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