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 6.0
1.0 MB
  |  
Oct 15, 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 · 24.1.2 · 24.4
Release notes

Added support for 24.4

Languages
English
OO Database Maintenance 5.9
957.2 KB
  |  
Jul 12, 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 · 24.1.2
Release notes

Added support for OO version 24.1.2

Languages
English
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
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
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
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
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
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
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
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
OO Database Maintenance 4.9
376.0 KB
  |  
Nov 19, 2019
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
Release notes

Added support for 2019.11.

Created new procedures for collecting and deleting historical data that utilize actual tables instead of in memory structures for faster and more reliable deletion.

Created a standalone procedure for deep clean in order to be able to run only the deep clean procedure instead of both regular purge and deep clean.

Added hard stops and error codes for both timeout and database error in order to avoid padded runtime.

Purge procedures now support the option to continue a timed out purge.

Before installing the new procedures make sure to run the included script for creating the supporting tables.

Created sample invocation scripts for postgresql procedures.

Languages
English
OO Database Maintenance 4.8
223.6 KB
  |  
Sep 3, 2019
More info Less info
Product compatibility
Version 10.2 · 10.10 · 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Version 2018.05 · 2018.09 · 2018.12
Version 2019.07
Release notes

Added 2019.07 to support matrix.

Added OO_EXECUTED_FLOW_GRAPH table to purge historical data.

Added for 2019.07 OO_RUNNING_EXEC_CONFIGS to purge plans procedure.

Removed retention period for running execution plans.

Languages
English
OO Database Maintenance 4.6
494.1 KB
  |  
Jan 18, 2019
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
Release notes

Added support for 2018.12

Languages
English
OO Database Maintenance 4.5
494.5 KB
  |  
Sep 25, 2018
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80 · 10.85
Version 2018.05 · 2018.08 · 2018.09 · 2018.12
Release notes

Added support for OO 2018.09

Languages
English
OO_Database_Maintenance 4.4
494.0 KB
  |  
Jul 16, 2018
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Version 2018.05
Release notes

Added support for 2018.05.

Added suport for purging running execution plans.

Languages
English
OO Database Maintenance Scripts 4.3.1
618.9 KB
  |  
Mar 7, 2018
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Release notes

Fixed MSSQL index  maintenance procedure.

Added MSSQL script to view current index fragmentation and page count

Languages
English
OO Database Maintenance Scripts 4.3
618.2 KB
  |  
Dec 4, 2017
More info Less info
Product compatibility
Version 10.20 · 10.50 · 10.51 · 10.60 · 10.70 · 10.80
Release notes

Added support for Operations Orchestration 10.80

Languages
English

Unsubscribe from notifications

You are receiving release updates for this item because you have subscribed to the following products:
If you unsubscribe, you will no longer receive any notifications for these products.
Tip: to update your subscription preferences, go to Manage Subscriptions from your Dashboard, uncheck the products you no longer want to receive notifications for, and click 'Save'.

Marketplace Terms of Service

In order to continue, you must accept the updated Marketplace Terms of Service.
Since you are downloading an app from the OpenText Marketplace, you need to accept the updated Marketplace Terms of Service before you can continue. Use the link to review the Marketplace Terms of Service. Once complete check the, "I accept the Marketplace Terms of Service" box below and click accept to continue your download.


Your download has begun...

Your download has begun

Related content and resources

Your browser is not supported!

Please upgrade to one of the following broswers: Internet Explorer 11 (or greater) or the latest version of Chrome or Firefox

release-rel-2024-12-3-sha256-6304 | Sun Dec 15 20:16:44 PST 2024