Disable displaying the output of SQL

[mzhu]

Hi everyone,

I am doing the workload testing by running scripts with SQLPLUS. It takes very long to finish desplaying the output of SQL statements, but actually I don't care the output at all. Is there any way to disable displaying the output but the whole output data are still put into the buffer cache?

Thanks for any help.

[sambavan]

  set serverout off

Sam

[mzhu]

Thanks for the reply.

But it still desplay the output afer I do "SET SERVEROUT OFF", why?

[sambavan]

The command that I gave you will suppress the dbms_output kind of messages. Looks like you are running a direct sql. Try creating a .sql file and invoke the sqlplus in the silent mode.

        SQLPLUS -S username/password @script.sql

In the script

     set feedback off
     set heading off
     set verify off
     set termout off
     spool output_file_name
     your sql statement
     spool off
     exit

Sam

[Edited by sambavan on 09-30-2002 at 06:47 PM]