My Oracle Support Banner

ODI Maintenance Tasks (Doc ID 2884777.1)

Last updated on DECEMBER 13, 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.


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

These maintenance activities should be performed for any ODI release.




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: Purge the historical values of ODI variables quarterly as well as prior to any upgrade and before applying ODI bundle patches which update the repository
 Task 4: Apply CPU patches and ODI Bundle Patches as they are released quarterly
 Task 5: Clear the nohup.out file

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