Re: put_line statements in Production code
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Sat, 7 Mar 2009 07:46:17 -0800 (PST)
Message-ID: <0319ddff-54b6-4f88-9fc8-4b3e91642ab3_at_w35g2000yqm.googlegroups.com>
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?
Date: Sat, 7 Mar 2009 07:46:17 -0800 (PST)
Message-ID: <0319ddff-54b6-4f88-9fc8-4b3e91642ab3_at_w35g2000yqm.googlegroups.com>
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