ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes

@opt2103

Hello Oracle Experts,

I am facing error : ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes when trying to run SQLT Trcanlzr method.

DB version : Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQLT_VERSION

----------------------------------------

SQLT version number: 12.2.180725

SQLT version date  : 2018-07-25

Installation date  : 2019-02-04/15:34:09

PFA sqltrcanlzr_error.log

I did some research for the error and tried both these below solutions but did not work:

1.set serveroutput on size unlimited

sqlplus user/pass@opt2103

exec sqltxadmin.sqlt$a.set_sess_param('connect_identifier', '@opt2103');

set serveroutput on size unlimited

START sqltrcanlzr.sql opt2103_ora_26353_Trig_param.trc