VERIFIED SOLUTION i

Resolve switching off plan logging for all Oracle batch Loaders

Product Feature: Repository

Operating System: Windows 2008 64bit

Database: Oracle
 

Issue

Switching off plan logging for all Oracle batch Loaders

Cause

Switching off plan logging for all Oracle batch Loaders via SQL can cause repository corruption.
 

Resolution

UPDATED: August 31, 2017
Logging path information is stored in fragment column of sarp table(s) which is not recommended to be modified. If these entries are removed from sarp tables, it could lead to repository corruption. Therefore it is recommended to remove logging manually.