Options to be specified in SQL control files which call multiple scripts

SET DEFINE OFF - if there are special characters to be inserted

SET ECHO ON - to get SQL statements executed along with their execution results.

SPOOL <path\file_name> - file name for spooling output. Make sure the user which runs the script has write permission in the directory where spool file will be written, else after scripts are complete, you will find yourself scratching your head for that missing spool file : )

SET TIMING ON - to get timings of various sql statements executed.

SET TERMOUT ON

SET TIME ON – to get time on command prompt. Quite useful when master control file runs many many queries and takes hours/minutes to run.