Why the ODS_PROCESS (10g) or the ODS_PROCESS_STATUS (11g and 12c) Table Should NOT Be Truncated (Doc ID 889673.1)

Last updated on AUGUST 30, 2023

Applies to:

Purpose

The document provides insight into the management of the oid processes, specifically the ods_process table within the 10g OID database and the ods_process_status table within the 11g OID database.

Scope

This information should be used when troubleshooting problems with OID processes not starting or processes being up when opmnctl shows them down, etc.

Many support engineers customarily direct the truncating of the ods_process/ods_process_status table.  This should NOT normally be done.  This document explains why.

Details

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