My Oracle Support Banner

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 FEBRUARY 12, 2019

Applies to:

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


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?



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

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