My Oracle Support Banner

Marketing Segmentation Cache Purge Not Working (Doc ID 483706.1)

Last updated on FEBRUARY 01, 2022

Applies to:

Siebel Campaigns - Version [18379] and later
Siebel Marketing - Version [18379] and later
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: [18379]
Database: Oracle
Application Server OS: Microsoft Windows 2003 Server
Database Server OS: HP 9000 Series HP-UX
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
 Message 1

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.