How to control the Maximum Output Size of an Enterprise Manager Job ( SQL or OS Command) other than default 10MB or 10486247 Bytes (Doc ID 2120863.1)

Last updated on JUNE 16, 2017

Applies to:

Enterprise Manager for Oracle Database - Version 11.1.0.1 and later
Enterprise Manager Base Platform - Version 11.1.0.1 and later
Information in this document applies to any platform.

Goal

Whenever an OS Command Job or SQL Script job is run via the Grid Control or Cloud Control Console, if the Job completes successfully, the job output is truncated at 10MB even though the output may exceed 10MB.

But when the OS Command or SQL is run outside of EM 11g Grid Control or EM12c or EM13c Cloud Control framework (eg shell, SQLPlus etc), the 10MB limitation for the output is not seen.

How can this limitation in EM 11g Grid Control or EM12c or EM13c Cloud Control be overcome and allow increase of the Job Output to a value greater than 10MB?

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms