SQL Plus - Flush System Variable

Card Puncher Data Processing


Flush is a system variable that controls when the output is sent to the user's display device.

OFF is recommended when:

  • you run a script that does not require user interaction
  • and whose output you do not need to see until the script finishes running.

OFF allows the host operating system to buffer output which may improve performance by reducing the amount of program input and output.

SET FLUSH is not supported in iSQL*Plus.

Discover More
Card Puncher Data Processing
SQL Plus - System Variable (Configuration)

System Variables Description APPI[NFO]{ON | OFF | text} Sets automatic registering of scripts through the DBMS_APPLICATION_INFO package. arraysize Sets the number of rows, called a batch, that SQLPlus...

Share this page:
Follow us:
Task Runner