Home » RDBMS Server » Performance Tuning » sql_trace question
sql_trace question [message #192303] Mon, 11 September 2006 14:01 Go to next message
rkl1
Messages: 97
Registered: June 2005
Member
Dear All:

I got a simple question. Now when we like to trace the sql statements, we use:

alter session set sql_trace=true; and then run our statements like

select * from emp;

and find out info after tkprof the .trc file. however, if we got a procedure which does some select using cursor and then insert to another table, is it possible to get info from the same sql_trace.

alter session set sql_trace=true;
execute proc1;
alter session set sql_trace=false;

Or is there any other tool to play around.

thanks.
Re: sql_trace question [message #192405 is a reply to message #192303] Tue, 12 September 2006 03:45 Go to previous message
AndreyPozhidaev
Messages: 9
Registered: December 2005
Location: St. Petersburg
Junior Member

you have to close cursor before end of trace.

and it is better:

alter session set sql_trace=true;
execute proc1;
exit;
instead 'of alter session set sql_trace=false;'
Previous Topic: enable Full-Text Search
Next Topic: Merge Partition into 1 single partition
Goto Forum:
  


Current Time: Tue Dec 03 12:57:16 CST 2024