Re: query tuning using tkprof80

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 2 Jul 1999 20:48:51 +0200
Message-ID: <930941282.3233.0.pluto.d4ee154e@news.demon.nl>

Hi Franz,
Could you connect as sys and describe this procedure (describe dbms_system etc). If that works you either don't have execute privilege or the public synonym for dbms_system doesn't exist.

Hth,

Sybrand Bakker, Oracle DBA

Franz Mueller <franz.mueller_at_orbis.de> wrote in message news:377ced1d.25100082_at_news.salink.net...
> Hi,
>
> I would like to trace the queries from a given app. How can I make a
> trace file that I could later analyze with "tkprof80"?
> If I try the "dbms_system.set_sql_trace_in_session(sid,serial,true)" I
> get a "identifier must be declared" error message. What is wrong?
>
> Thank you
> Franz
Received on Fri Jul 02 1999 - 13:48:51 CDT