21 May
Performance of Autotrace
I have been having some performance problems when using autotrace in some production systems. I finally had time to check out why.
I enabled sql trace in my autotrace session to see what was causing the slow response. As you may already know setting autotrace on opens another session other than the session you are executing your query in. This second session reports statistics of the main