ORA-20000 / ORU-10027: Using DBMS_OUTPUT with DBMS_STATS.GATHER_SCHEMA_STATS (Doc ID 247713.1)

Last updated on MAY 01, 2017

Applies to:

PL/SQL - Version 8.1.5.0 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Nov-2015***


Symptoms

Using DBMS_STATS.GATHER_SCHEMA_STATS and DBMS_OUTPUT procedures in the PL/SQL  gives

ORA-20000: ORU-10027: buffer overflow, limit of 10000 bytes
ORA-6512: at "SYS.DBMS_OUTPUT", line %0!%
ORA-6512: at line %1!%

Cause

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