Fine tune Database for BPM Suite 6

Solution Unverified - Updated -

Issue

  • We're experiencing some performance issues at the database level, and want to make some improvements at that level;
  • We've installed BPMS 6.2.3.GA running on a Oracle 12c Database. Please provide the link to download the sql scripts for fine tuning this database;
  • We have a performance problem with BPMS, it is taking a long time for the tasks to be executed, when analyzing it was detected that 80% of the time goes in the elimination of the taskVARIABLEIMPL table, the time to eliminate records is taking 42.1 seconds on average.

Environment

Red Hat JBoss BPM Suite 6.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In