EM 12c: Siebel Database Repository (DBstore) Target Shows Excessive CPU Usage in Enterprise Manager 12c Cloud Control (Doc ID 2035687.1)

Last updated on DECEMBER 07, 2015

Applies to:

Enterprise Manager for Siebel - Version 12.1.0.3.0 and later
Information in this document applies to any platform.

Symptoms

The Siebel Database Repository target monitored in Enterprise Manager 12c Cloud Control is experiencing critical performance problems, seeing 100% CPU usage. Multiple SIEBEL database user sessions are running simultaneously via odbcsql with queries like:

SELECT COUNT(*) FROM SIEBEL.S_CONTACT WHERE CREATED > 'timestamp';

SELECT COUNT(ROW_ID) FROM SIEBEL.S_EVT_ACT WHERE CREATED > 'timestamp';

 

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