Symptoms

We are currently using the caching functionality for Siebel Marketing Segmentation to improve system performance. We have the default cache expiration time set to 24 hours. Our understanding is that when segmentation results are cached they are written to the M_C_CONTACT table in the warehouse. After 24 hours, the results expire and the Siebel server runs a SQL script to delete the cached records from M_C_CONTACT.

We have found that this delete process does not work consistently. Even though cache records are expired, they are not always deleted from M_C_CONTACT. This table continues to grow and eventually becomes a perormance bottleneck because the cache table gets so large. We've implemented a workaround where we truncate M_C_CONTACT manually once per week to alleviate the issue. My question is why aren't expired cache records consistently deleted from M_C_CONTACT?

Cause

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 hundreds of Community platforms