ODI Maintenance Tasks (Doc ID 2884777.1)

Last updated on JANUARY 27, 2025

Applies to:

Oracle Data Integrator - Version 11.1.1.9.0 and later
Oracle Data Integrator on Marketplace - Version 2.0.2 and later
Information in this document applies to any platform.

Purpose

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.

Questions and Answers

	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

Questions and Answers

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.