-
Tuning SQL
Hey,
what is the major difference between
set autotrace on
and
alter session set sql_trace=true
-
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
-
autotrace outputs to screen
sql_trace writes to a trace file
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|