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 11.1.1.9.0 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.

Scope

 

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
Scope
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: 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
References

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