Description

Scripts used for the maintenance of the OO database: purging, index and size maintenance. Available for MSSQL, Oracle and PostgreSQL

Suggested apps

Suggested for you are based on app category, product compatibility, popularity, rating and newness. Some apps may not show based on entitlements. Learn more about entitlements.

Releases

Release
Size
Date
OO Database Maintenance 5.8
971.0 KB
  |  
Apr 8, 2024
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Version 2018.05 · 2018.09 · 2018.12
Version 2019.07 · 2019.11
Version 2020.02 · 2020.08
Version 2021.02
Version 2022.05 · 2022.11
Version 2023.05
Version 24.1 · 24.1.1
Release notes

Added support for 24.1.1

Languages
English
Files
OO Database Maintenance 5.6
857.3 KB
  |  
May 23, 2023
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Version 2018.05 · 2018.09 · 2018.12
Version 2019.07 · 2019.11
Version 2020.02 · 2020.08
Version 2021.02
Version 2022.05 · 2022.11
Version 2023.05
Release notes

Added support for 2023.05 release. On OO 2023.05 release split the plans and exec configs into separate procedures based on new functionality from 2023.05.

Languages
English
Files
OO Database Maintenance 5.5
777.9 KB
  |  
Dec 6, 2022
More info Less info
Product compatibility
Version 10.10 · 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Version 2018.05 · 2018.09 · 2018.12
Version 2019.07 · 2019.11
Version 2020.02 · 2020.08
Version 2021.02
Version 2022.05 · 2022.11
Release notes

Added compatibility for 2022.11 release and fixed a typo in naming for a PostgreSQL file name.

Languages
English
Files
OO Database Maintenance 5.4
775.6 KB
  |  
Jun 17, 2022
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Version 2018.05 · 2018.09 · 2018.12
Version 2019.07 · 2019.11
Version 2020.02 · 2020.08
Version 2021.02
Version 2022.05
Release notes

Added support for 2022.05

Languages
English
Files
OO Database Maintenance 5.3
697.1 KB
  |  
Mar 18, 2021
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Version 2018.05 · 2018.09 · 2018.12
Version 2019.07 · 2019.11
Version 2020.02 · 2020.08
Version 2021.02
Release notes

Added support for 2021.02.

Improved delete method for auxiliary execution data to better remove data from execution bound inputs, execution bound outputs and executed flow graph tables.

Fixed potential duplicate entry on MySQL procedures (10.60 to 2020.08 versions).


Languages
English
Files
OO Database Maintenance 5.2
539.3 KB
  |  
Oct 13, 2020
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Version 2018.05 · 2018.09 · 2018.12
Version 2019.07 · 2019.11
Version 2020.02 · 2020.08
Release notes

Fixed MSSQL deep clean procedure to improve performance of delete.

Fixed on MSSQL a potential endless loop on next delete batch population.

Languages
English
Files
OO Database Maintenance 5.1
538.2 KB
  |  
Sep 14, 2020
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Version 2018.05 · 2018.09 · 2018.12
Version 2019.07 · 2019.11
Version 2020.02 · 2020.08
Release notes

Added support for OO 2020.08.

Added MySQL procedures starting with 10.60. MySQL procedures only compatible with 5.6 and 5.7

Reduced min batch size to 10,000 where previously was set for 1,000,000 in order to reduce resource contention on weaker databases.

Languages
English
Files
OO Database Maintenance 5.0
495.7 KB
  |  
Mar 19, 2020
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Version 2018.05 · 2018.09 · 2018.12
Version 2019.02 · 2019.07 · 2019.11
Version 2020.02
Release notes

Added support for 2020.02, added purge remote debug procedure, fixed a possible collision issue on purging of running exec configs.

Languages
English
Files
OO Database Maintenance 4.9
376.0 KB
  |  
Nov 19, 2019
More info Less info
Product compatibility