Re: tracing

From: Dave <x_at_x.com>
Date: Wed, 30 Mar 2005 19:27:35 GMT
Message-ID: <H4D2e.268$G8.230@text.news.blueyonder.co.uk>

"Eugene" <epipko_at_hotmail.com> wrote in message news:1112210461.034219.244640_at_l41g2000cwc.googlegroups.com...
> Hi all,
> I have a process that connects to the d/base and does a select.
> Then it disconnects and performs some tasks. Then it connects and
> updates lots of rows. That update is taking too long. I'd like to be
> able to trace it to see the tkprof of it, but my DBA said that it is
> impossible because she doesn't know the session_id.
> Is is really not possible, or? Is there a supplied package that I can
> use?
>
> Thanks,
> Eugene
>

logon trigger to set sql_trace = true

or find the sid from v$session and use dbms_system.set_ev or set_sql_trace_in_session

get a new dba Received on Wed Mar 30 2005 - 13:27:35 CST