Re: Tracing in Packages

Thanks for your help. I just discovered this program TKPROF. It works fine... but I cannot use the EXPLAIN=UserName/Password feature. I cannot make a connection to a interface from the command line (maybe I should be running TKPROF not from the command line?). How can I get this to work for me. Do I need to set a Default Connect String somewhere or what?

Any held deeply appreciated.
Bjarni Ragnarsson
bjarnir_at_centrum.is

Sybrand Bakker wrote:

> You'll need to trace your session, by issuing alter session set sql_trace =
> true. This will also trace the packages.
> Alternatively you could use the dbms_session package to accomplish the same.
> To enable trace for a session different than your own , use
> dbms_system.set_sql_trace_in_session(sid, serial#,true) where sid and
> serial# can be retrieved from v$session.
>
> The trace file will end up in the user_dump_dest directory on the server.
>
> Then run tkprof73 on it, and you have your plans. Make sure the init.ora
> parameter timed_statistics has been set to true.
>
> Hth,
> --
> Sybrand Bakker, Oracle DBA
>
> Bjarni Ragnarsson <bjarnir_at_centrum.is> wrote in message
> news:37E4B2F7.AA826697_at_centrum.is...
> > Hi.
> >
> > Is there a way to trace inside a PL/SQL package (in Oracle 7.3).
> > I'm looking for Autotrace (Explain path, statistics etc) and Timing for
> > individual procedures/functions and SQL-queries inside them.
> >
> > Thanks in advance,
> > Bjarni Ragnarsson
> > bjarnir_at_centrum.is
> >

--
Bjarni Ragnarsson
bjarnir_at_centrum.is Received on Sun Sep 19 1999 - 16:26:51 CDT