Clearing the Siebel Configurator Cache to Improve Performance

The best practice is to force a full resynchronization of the Siebel Product Configurator cache periodically. For example, you might resynchronize the cache once a month, when there is a low load on the Siebel application. How often you should actually resynchronize the cache depends on how rapidly changes to versioned objects accumulate over time in your implementation.

Two special tables, S_VOD_CASHESYNC and S_VOD_CACHEREQ are used to drive the synchronization process and are queried frequently. Records in those tables are hold temporary information that facilitate cache synchronization. This information can accumulate over time, causing performance degradation. You notice this degradation as queries become slower.

To force resynchronization, select the menu option that invokes the ResetSKC method to clear the full Siebel Product Configurator cache for Products, Product Classes and Attribute Definitions.

To clear the Siebel Product Configurator cache to speed queries

1. Navigate to the Administration - Products screen, then the Cache Administration view.

2. From the applet menu, select Refresh Cache.