ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Oracle Table Analyze job taking hours to complete

book

Article ID: 133633

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

Oracle Table Analyze job is taking too long, it's taking hours, although it is scheduled to run during off-peak hours. 

Environment

Release :

Component : CA Cloud Test

Resolution

The Oracle Table Analyze job is simply an interface with which Clarity PPM calls Oracle database statistics. So if the job is taking long time, this would mean that the database statistics run for long time. This is not a Clarity product issue, and our recommendation is to work with your DBA to see what they think the root cause for this is (they can run AWR report for the time of execution and review it). They should be able to advise on next steps.

If they find that they would prefer running statistics in a different way, and not run the Oracle Table Analyze job from Clarity, this is completely supported, just make sure that they gather all the stats for Clarity schema.