SQL Plus - Flush System Variable

Card Puncher Data Processing

About

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
System Variable

s 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 will fetch...



Share this page:
Follow us:
Task Runner