Troubleshooting OmniChannel Provider database performance issues

Last Updated : Apr 23, 2021 |

Condition

The performance of search queries, such as Avaya Oceana® Data Viewer or Avaya Workspaces for Avaya Oceana® search queries, is slow.

Cause

The number of contacts and customers in the OmniChannel Provider (OCP) database exceeds the supported limits. This issue also occurs if the number of contacts per customer exceeds supported limits.

Solution

Procedure

  1. Ensure that the number of contacts and customers in the OCP database is within supported limits.
  2. Ensure that the number of contacts per customer is within supported limits.

    Use the Oceana Data Management utility to clean up the OCP database if the number of contacts per customer exceeds supported limits. For more information about supported limits of contacts per customer, see Statistics home page.

  3. If the issue persists, review the performance of the disk on which the OCP database is mounted.