How to control the Maximum Output Size of an Enterprise Manager Job ( SQL or OS Command) other than default 10MB or 10486247 Bytes
Last updated on JUNE 16, 2017
Applies to:Enterprise Manager for Oracle Database - Version 188.8.131.52 and later
Enterprise Manager Base Platform - Version 184.108.40.206 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?
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