Hi,
We sometimes get strange errors from our oracle database when the engine is querying for an execution (see below).
Our DBAs now increased the value for PGA in our oracle instance from 8 to 16.
As I didn’t find any official documentation: Is there any recommendation for the value of PGA_AGGREGATE_LIMIT for an Camunda engine which uses Oracle Exadata as database?
Thanks
Wolfgang
Error querying database. Cause: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Execution.xml
The error may involve org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.selectExecution-Inline
The error occurred while setting parameters
SQL: select * from ACT_RU_EXECUTION where ID_ = ?
Cause: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT