Clarity PPM: Oracle Database Performance Issues

book

Article ID: 125120

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Our DBA team has been identifying several very long running sessions in the Clarity database. The database sessions needed to be killed and it is a problem that keeps coming back. We are unable to identify a root cause.
 

Cause

This issue can be caused by one or more of the following:

1. Database issues/changes.

2. Load Balancer configuration

3. Environmental/migration changes

Environment

Release:
Component: PPMPRD

Resolution

1. Check if the APP and BG logs to see if there is a message related to the database connection, e.g.



java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]Object has been closed. 
at com.ca.clarity.jdbc.oraclebase.ddcr.b(Unknown Source) 



2. Please have the DBA team review and confirm that the required Oracle database parameters and settings are set in order for Clarity to perform at the most optimal performance.
Based on the v$parameters results and the AWR analysis, indexes will need to be rebuilt

http://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/15-8/installing-and-upgrading/install-clarity-ppm.html#concept.dita_c5fddf2f732699e579d4affe4d72b1178454ee97_ConfigureaPPMDatabasewithOracle

Section: Configure a PPM Database with Oracle