DBMS_OUTPUT

From: BHAVESH PATEL <BHAVESH-PATEL_at_worldnet.att.net>
Date: 1997/10/18
Message-ID: <629a3e$pp5@bgtnsc02.worldnet.att.net>#1/1

Can someone tell me the following,

If the SERVEROUTPUT is off and the Procedure does includes DBMS_OUTPUT statements in the procedure. Does this statement degrades the performance.
Is there an tangible performance hit related to the number of lines in a program, even if they don't execute:

     e.g.  IF 1=2 THEN
                500 lines
           ELSE
                1 line
           END IF

3) Is size limit on stored procedures based on line count or byte count? And what is the limit.

Thanks
Bhavesh Patel. Received on Sat Oct 18 1997 - 00:00:00 CDT