Database defragmentation overview

Last Updated : Nov 03, 2021 |

The Oceana Data Management utility includes the Defragmentation tab. Using this tab, you can perform the defragmentation process on the Omnichannel database and view the defragmentation history.

Over time the data in the Omnichannel database becomes fragmented, which can lead to performance degradation. To improve the database performance, you can use defragmentation. Avaya recommends running the defragmentation process every 6-9 months, but only if you experience performance degradation.

Before the defragmentation process starts, Avaya Oceana® performs two checks:
  1. Checking if enough disk space is available as the defragmentation process requires additional disk space, up to 100% of the database size. When the defragmentation process is complete, Avaya Oceana® returns the disk space to the operating system.

  2. Checking if there is another uncompleted defragmentation process. Avaya Oceana® can run only one defragmentation process at a time.

If the checks are successful, the defragmentation process starts. You can check the defragmentation process status in the Check Defragmentation section.

Note:

The duration of the defragmentation process depends on the size of the Omnichannel database. It takes approximately one minute per gigabyte of the database size. You can refer to the Defragmentation History tab to see how long the previous defragmentation processes took. This information will help you estimate the duration of the current defragmentation process.

Defragmentation History

On the Defragmentation History tab, you can view the information about previous defragmentation processes, which are listed in chronological order. The information includes start and end times and overall time for the defragmentation in seconds. The Defragmentation History tab displays the following information for the last 100 processes:
  • Defragmentation status

  • Start time

  • End time

  • Overall process time