Clarity: Slow database performance after upgrading to Oracle 10.2.0.4

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• Clarity PPM SaaS
• Clarity PPM On Premise

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: