Clarity: Slow database performance after upgrading to Oracle


Article ID: 51117


Updated On:


CLARITY PPM FOR ITG CLARITY PPM FEDERAL CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS Clarity PPM On Premise



My database seems to run more slowly after upgrading to Oracle Why?


Items to check with your Database Administrator's (DBA) assistance:

  1. Set the Oracle optimizer to
  2. Run the Oracle Table Analyze job with Analyze percent at 50%
  3. Check SGA/PGA sizes are adequate for database size and activity
  4. Refer to the Clarity Install Guide - 'Performance' section
  5. Check for Clarity Jobs that have a status of 'Processing' that seem to be not finishing in suitable amount of time. Most likely these jobs are hung. Cancel these jobs and reschedule them

If performance issues persist, please open a Clarity Support ticket and attach an AWR report during a period when slow performance was experienced.


Release: ESPCLA99000-12.1-Clarity-Extended Support Plus