Re: Tracing in Packages

You should use explain=username/password_at_servicename (found in tnsnames.ora), or create the LOCAL string in the registry at HKLM\software\oracle, and have that equal to your default database.

Hth,

Sybrand Bakker, Oracle DBA

On Sun, 19 Sep 1999 22:26:51 +0100, Bjarni Ragnarsson <bjarnir_at_centrum.is> wrote:

>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 - 23:27:06 CDT