My Oracle Support Banner

Performance Issue Encountered When Clicking On The [Status/Notes] Button. (Doc ID 3000273.1)

Last updated on JANUARY 26, 2024

Applies to:

Oracle Thesaurus Management System - Version 5.3.1 and later
Information in this document applies to any platform.

Symptoms

1)
Performance issue encountered when:

 

2)
This was only happening for a 'non-super' user.

 

3)
Below query was found to be problematic:

 

4)
Issue goes goes away when the TMS tables are analyzed using the 'Analyze Tables' job from within the TMS UI. This can be seen in the below execution plans:

 

5)
Issue subsequently returns.

 

6)
Customer has a heavily skewed TMS_DICT_CONTENTS table i.e.

 

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.