Clarity: Slow database performance after upgrading to Oracle 10.2.0.4

Article Id: 51117
Status: Published
Updated On: 14-02-2018 06:38
Legacy Id: TEC532931
Products:
CA Identity Manager , CA Identity Governance , CA Identity Portal , STARTER PACK-CLARITY PPM
Issue/Introduction:

Description:

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

Solution:

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

  1. Set the Oracle optimizer to 10.2.0.4
  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.

Environment:

Release: ESPCLA99000-12.1-Clarity-Extended Support Plus
Component: