Download SQL*Plus User's Guide and Reference

SQL*Plus Script Tuning
SET LINESIZE
SET LINESIZE sets the total number of characters that SQL*Plus displays on one
line before beginning a new line.
Keep LINESIZE as small as possible to avoid extra memory allocations and memory
copying.
However, if LINESIZE is too small, columns that cannot fit next to each other are
put on separate lines. This may reduce performance significantly.
SET LONGCHUNKSIZE
SET LONGCHUNKSIZE sets the size of the increments SQL*Plus uses to retrieve a
CLOB, LONG, NCLOB or XMLType value.
Experiment with different sizes if LONGS or LOBs are being fetched.
SET PAGESIZE
Sets the number of rows on each page of output in iSQL*Plus, and the number of
lines on each page of output in command-line and Windows GUI.
Increase PAGESIZE to avoid printing headings frequently, or set it to 0 to prevent
headings being displayed.
SET SERVEROUTPUT
SET SERVEROUTPUT OFF suppresses the display output (DBMS_OUTPUT.PUT_
LINE) of stored procedures or PL/SQL blocks in SQL*Plus.
Setting SERVEROUTPUT OFF stops internal SQL*Plus calls to the DBMS_OUTPUT
package done after user SQL statements.
SET SQLPROMPT
Sets the SQL*Plus command prompt.
Use the default prompt, "SQL> " to stop variable substitution occurring each time
the prompt is displayed.
SET SQLPROMPT is not supported in iSQL*Plus
Tuning SQL*Plus
9-13