Slow ZCC, high db activity for Oracle ZCM setup

  • 7007666
  • 25-Jan-2011
  • 23-Nov-2012

Environment

Novell ZENworks 10 Configuration Management
Novell ZENworks 11 Configuration Management

Situation

Some ZCC actions such as deleting a workstation take a long time and cause Oracle database to show high utilization and disk I/O.

Resolution

ZCM 10.3.2: This is fixed in version 10.3.2 - see KB 7007237 "ZENworks Configuration Management 10.3.2 - update information and list of fixes" which can be found at https://www.novell.com/support
Some new indexes and triggers were added to the database for Oracle specific issues.
 
ZCM 11:  This is fixed in version 11.1 - see KB 7008746 "ZENworks Configuration Management 11.1 - update information and list of fixes" which can be found at https://www.novell.com/support