Scripts used for the maintenance of the OO database: purging, index and size maintenance. Available for MSSQL, Oracle and PostgreSQL
Fixed MSSQL deep clean procedure to improve performance of delete.
Fixed on MSSQL a potential endless loop on next delete batch population.
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.
Added support for 2020.02, added purge remote debug procedure, fixed a possible collision issue on purging of running exec configs.
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.
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.
Added support for 2018.05.
Added suport for purging running execution plans.
Fixed MSSQL index maintenance procedure.
Added MSSQL script to view current index fragmentation and page count
Similar apps are based on app category, product compatibility, popularity, rating and newness. Some apps may not show based on entitlements. Learn more about entitlements.
Related content and resources
Please upgrade to one of the following broswers: Internet Explorer 11 (or greater) or the latest version of Chrome or Firefox