| sql_trace question [message #192303] |
Mon, 11 September 2006 14:01  |
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  |
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;'
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
