SQL Performance (MOSC)

MOSC Banner

SQLT Oracle 12c

edited Dec 18, 2019 4:03AM in SQL Performance (MOSC) 5 commentsAnswered

Hi, I'm using Oracle Database Standard 12.2.0.1.0  and I installed the SQLT

SQLT version number: 19.0.190705

SQLT version date  : 2019-07-05

Installation date  : 2019-11-30/15:12:54

My file of trace is 5.9gb and when I try analyze with command @sqltrcanlzr.sql ora_32073.trc, this error is showed end of file.

BEGIN SQLTXADMIN.trca$i.trcanlzr(p_file_name => 'ora_32073.trc', x_tool_execution_id => :v_tool_execution_id); END;

*

ERROR at line 1:

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

ORA-06512: at "SYS.DBMS_OUTPUT", line 32

ORA-06512: at "SYS.DBMS_OUTPUT", line 97

ORA-06512: at "SYS.DBMS_OUTPUT", line 112

ORA-06512: at "SQLTXADMIN.TRCA$G", line 211

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center