Tuning SQL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Tuning SQL

  1. #1
    Join Date
    Apr 2003
    Posts
    32

    Tuning SQL

    Hey,

    what is the major difference between

    set autotrace on

    and

    alter session set sql_trace=true

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    autotrace does not give you spu time and the value of the bind variables..etc..but i think you should test and see for yourself..dont know why are you asking this question ?

    I think teh major difference is aet autotrace will show the plan that the optimizer will use...at times it can lie..alter session is kind of a post mortem..which will tell you what exactly happened..

    You cannot do autotrace on pls/sql programs or btach programmes or say 3rd party applications..if you want to tune a single query auto trace rocks else it is alter session set sql_trace=true;

    regards
    Hrishy

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    autotrace outputs to screen

    sql_trace writes to a trace file

  4. #4
    Join Date
    Feb 2003
    Posts
    85

    Re: Tuning SQL

    Originally posted by freedba
    Hey,

    what is the major difference between

    set autotrace on

    and

    alter session set sql_trace=true

    lafff

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