Re: put_line statements in Production code

From: Mark D Powell <>
Date: Sat, 7 Mar 2009 07:46:17 -0800 (PST)
Message-ID: <>

On Mar 6, 9:10 pm, Nomen Nescio <> wrote:
> Is there a significant performance penalty if dbms_output.put_line()
> statements are not removed from code that goes to Production?

Having valid dbms_output statements in your production code where you do not want to see the output will waste a little cpu but more importantly it will increase the tasks memory requirements. It is also possible that your application could experience some buffer overflow errors due to the dbms_output buffers filling up under production volumes if set serveroutput is on.

HTH -- Mark D Powell -- Received on Sat Mar 07 2009 - 09:46:17 CST

Original text of this message