Uploaded image for project: 'Red Hat Process Automation Manager'
  1. Red Hat Process Automation Manager
  2. RHPAM-3781

Oracle - Long running query at kie-server startup

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 7.10.0.GA
    • None
    • None
      • Oracle 19c.
      • RHPAM 7.10.0

    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

        Activity

          People

            rhn-support-spatra Sweta Patra
            rhn-support-spatra Sweta Patra
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: