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 11.1.1.9.0 and later
Information in this document applies to any platform.
These maintenance activities should be performed for any ODI release.

Purpose

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

Details

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
Purpose
Details
 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
References

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