Curiously metalink note confirms SQL_TRACE is obsolete Note:316889.1.
But in oracle 10gr2 manual Performance tuning guide
says
"Step 2: Enabling the SQL Trace Facility
Enable the SQL Trace facility for the session by using one of the following:
DBMS_SESSION.SET_SQL_TRACE procedure
ALTER SESSION SET SQL_TRACE = TRUE;
To disable the SQL Trace facility for the session, enter:
ALTER SESSION SET SQL_TRACE = FALSE;"
I'm understading let me see, this is obsolete, but still necessary :)
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 11 2005 - 07:02:05 CST
