Marketing Segmentation Cache Purge Not Working
(Doc ID 483706.1)
Last updated on JULY 21, 2020
Applies to:Siebel Campaigns - Version 18.104.22.168  and later
Siebel Marketing - Version 22.214.171.124  and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 126.96.36.199 
Database: Oracle 188.8.131.52
Application Server OS: Microsoft Windows 2003 Server
Database Server OS: HP 9000 Series HP-UX
***Checked for relevance on 02-Set-2013***
This document was previously published as Siebel SR 38-3450727901.
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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document