Is DB schema audit logging on BPM schema table enabled by BPMS installer ?

Solution Unverified - Updated -

Issue

We are on BPM 6.4.0 version. Recently we had a critical performance issue across all applications. While reviewing the ORACLE session DBAs noted that we have enabled audit for delete statement on WorkItemInfo table. This table is heavily used considering the amount of data being processed and they mentioned that since audit is enabled it is talking a lot of oracle memory and causing delays in processing. we reviewed other tables in the BPM schema and I see audit is enabled for most of the tables. I would like to understand if the audit option is enabled on all tables in this schema as part of the installation and it is required or it may been enabled by us somehow ?

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
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.