Details
-
Bug
-
Resolution: Done
-
Major
-
None
-
7.48.0.Final
-
None
-
False
-
False
-
NEW
-
NEW
-
Undefined
Description
Slow server startup due to query registration at Oracle 19c.
When we have 900000 or more records in VariableInstanceLog, the following RHPAM SQL query takes long time to respond and times out even after 15 minutes in the DEV environment
~~~~~~
SELECT * FROM (SELECT VIL.PROCESSINSTANCEID, VIL.PROCESSID, VIL.ID, VIL.VARIABLEID, VIL.VALUE FROM VARIABLEINSTANCELOG VIL LEFT JOIN VARIABLEINSTANCELOG VIL2 ON VIL.PROCESSINSTANCEID = VIL2.PROCESSINSTANCEID AND VIL.VARIABLEID = VIL2.VARIABLEID AND VIL.ID < VIL2.ID WHERE VIL2.ID IS NULL) "dbSQL" FETCH FIRST 0 ROWS ONLY
Attachments
Issue Links
- is cloned by
-
RHPAM-3782 Oracle - Long running query at kie-server startup
- Closed