Re: set_sql_trace_in_session

From: <IlicR_at_stentor.ca>
Date: Thu, 4 May 2000 13:25:55 -0400
Message-Id: <10487.104951@fatcity.com>

Try this :
alter session set sql_trace = true
alter system set timed_statistic = true
After that execute dbms_system.set_sql_trace_in_session(sid,serial#,true);

.................

run tkprof to interprate you dump

P.S Don't forget to run again
alter session set sql_trace = false
alter system set timed_statistic = false

Hope it helps... Received on Thu May 04 2000 - 12:25:55 CDT