My Oracle Support Banner

Operations On Table Variable Take More Than 30 Seconds To Complete (Doc ID 2757537.1)

Last updated on MARCH 04, 2021

Applies to:

Oracle Insurance Insbridge Rating and Underwriting - Version 5.6.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 5.6.0.0.0 version, RateManager

ACTUAL BEHAVIOR
---------------
Operations on Table Variable take more than 30 seconds to complete

When we create, update or delete a Table Variable in the RateManager, it takes more than 30 seconds to complete. In our 5.4 version, those operations are executed almost instantly.

We tried with local and global variables, in different products and it's always the same result.

It also takes more than 30 seconds to create a new table revision; even if the table has no data in it.

EXPECTED BEHAVIOR
-----------------------
Updating a table variable should not take more than 30 seconds to complete.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1-Create a new local or global variable
  Type a name and a default value
  Save
2-The RM freezes for at least 30 seconds
3- The variable has been created.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, there is a performance issue with RM.

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
Cause
Solution
References


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