Re: put_line statements in Production code
Date: Sat, 7 Mar 2009 07:46:17 -0800 (PST)
On Mar 6, 9:10 pm, Nomen Nescio <nob..._at_dizum.com> 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