My Oracle Support Banner

ODI Maintenance Tasks (Doc ID 2884777.1)

Last updated on MARCH 10, 2023

Applies to:

Oracle Data Integrator on Marketplace - Version 2.0.2 and later
Oracle Data Integrator - Version and later
Information in this document applies to any platform.
These maintenance activities should be performed for any ODI release.


 This document shows what maintenance actions should be performed on Oracle Data Integrator (ODI) to reduce occurrence of performance reduction and other problems.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 The following Maintenance should be performed regularly (the recommended interval is mentioned under each task):
 Task 1: DB Maintenance - Compute Statistics to reclaim wasted space after running a purge and weekly
 Task 2: Purge the Sessions log and the Scenario reports weekly
 Task 3: Apply CPU patches and ODI Bundle Patches as they are released quarterly

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.