TURN OFF output in sql*plus
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: TURN OFF output in sql*plus

  1. #1
    Join Date
    Oct 2002
    Location
    CA
    Posts
    67

    TURN OFF output in sql*plus

    Quick question. How to turn off sql output in sql*plus without using spool or count(*) stuff. I just want to time(turn on timing option) my queries for performance tuning.
    --------------------------------------
    It's not what the world does to you that matters. It's how you respond...

  2. #2
    Join Date
    Dec 2001
    Posts
    221
    You can use
    set autotrace traceonly
    statement for it.
    you can refere oracle docs for detailed explanation of set autotrace
    Santosh Jadhav
    8i OCP DBA

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