Disable displaying the output of SQL

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.

Code:

---


  set serverout off

---

Sam

Thanks for the reply.

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

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.

Code:

---


        SQLPLUS -S username/password @script.sql

---

In the script

Code:

---

    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]