My Oracle Support Banner

S_SRM_REQUEST NOT cleaned up (Doc ID 523007.1)

Last updated on MARCH 13, 2018

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

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
Symptoms
Cause
Solution
 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.