Re: running TKPROF from a Application

At the beginning of your application use dbms_session.set_trace_on(TRUE);
//codes of your application
dbms_session.set_trace_on(FALSE);

if you can not change the code, you may use the following procedure

 "dbms_system.set_sql_trace_in_session(sid number, serial# number,

                              sql_trace boolean);

• Enable sql_trace in the session identified by (sid, serial#). These
• value are gotten from v$session.
• Input arguments:
• sid
• session id
• serial#
• session serial number
• sql_trace
• if true then enable tracing, if false disable tracing. "

Stefan Keller wrote:

> i try to use the Oracle-TKPROF trace utillity, for tuning reasons.
> that works well when i run tkprof from sqlplus, but that way i have to
> copy the sql's into sqlplus environment.
>
> now i tried to run tkprof from my Centura application.
> for that i have to set the TRACE-mode to TRUE
> how can i do that?

--
-------------------------------------------------------------------
Abu M Rahman                     | PHONE: (904) 737-3181 ext. 237
Database Administrator           | FAX  : (904) 739-1984
NKO, Inc.                        | Email: arahman_at_nko.com
-------------------------------------------------------------------