Weblogic Managed Server where Demantra is Deployed is Taking Long Time To Start
(Doc ID 2827419.1)
Last updated on AUGUST 17, 2022
Applies to:Oracle Demantra Demand Management - Version 12.2.7 and later
Information in this document applies to any platform.
On : 12.2.7 version, Technical
After upgrading database to 19c, the Weblogic Server where demantra application is deployed, is taking long time to start .
Bellow SQL was noticed to take long as per AWR report :
SELECT statement with SQL_ID
SQL statement with SQL_ID 4dxjgzk230w21.
SELECT NULL AS table_cat,
c.owner AS table_schem,
c.position AS key_seq,
c.constraint_name AS pk_name
FROM all_cons_columns c, all_constraints k
WHERE k.constraint_type = :"SYS_B_0"
AND k.table_name = :1
AND k.owner like :2 escape :"SYS_B_1"
AND k.constraint_name = c.constraint_name
AND k.table_name = c.table_name
AND k.owner = c.owner
ORDER BY column_name
The SQL_ID "4dxjgzk230w21" should run fast on 19c and the weblogic and demantra application to start in less time.
The issue can be reproduced at will with the following steps:
1. Upgrade database to 19c
2. Start up weblogic server
It is taking long time to start.
DB upgrade to 19c.
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