Re: Tracing in Packages

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Sun, 19 Sep 1999 14:49:42 +0200
Message-ID: <937745452.13604.0.pluto.d4ee154e@news.demon.nl>

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
>
Received on Sun Sep 19 1999 - 07:49:42 CDT