Disable displaying the output of SQL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Disable displaying the output of SQL

  1. #1
    Join Date
    Mar 2001
    Posts
    109
    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.
    zm

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Code:
      set serverout off
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Mar 2001
    Posts
    109
    Thanks for the reply.

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

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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]
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width