S_SRM_REQUEST NOT cleaned up

(Doc ID 523007.1)

Last updated on OCTOBER 13, 2016

Applies to:

Siebel CRM - Version 8.1.1.11.17 [IP2013] to 8.1.1.11.17 [IP2013] [Release V8]
Siebel System Software - Version 7.5.3.11 [16199] to 8.2.2 SIA[22320] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise) and Later
Version: 7.5.3.11 [16199]
Database: Oracle 8.1.7.3
Application Server OS: Microsoft Windows 2000 Server SP 3
Database Server OS: HP-UX 11.0


***Checked for relevance on 16-JUL-2014***


Symptoms

We have an issue with S_SRM_REQUEST table. There are 5 million records residing on that and never was cleaned up. That’s because the server table clean up component was not enabled. This is causing some performance issues. We would now want to cleanup this table with our DBA help. Can you please let us know the process for doing this?

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