07 Apr
An effect of sql_trace=true
Tom Kyte has a recent post about explain plan.
In that there is something I have not realized before that I want to share. When you execute a sql statement after you set sql_trace=true it is hard parsed again even if it is already in the shared pool.
A simple test is below.
SQL> select ‘test’ from dual;
‘TES
—-
test
SQL> alter session set sql_trace=true;
Session altered.
SQL> select ‘