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 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?
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