Re: Trace SQL commands in PL/SQL

From: Michael Bialik <michael_bialik_at_my-deja.com>
Date: Mon, 18 Sep 2000 20:41:32 GMT
Message-ID: <8q5uln$bso$1@nnrp1.deja.com>

Hi.

DBMS_PROFILER is used to trace PL/SQL (nothing exists prior to 8i).

I understood you would like to trace your SQL statements, so DBMS_SESSION.SET_SQL_TRACE ( TRUE ); will work for you without problems. ( You will have to run TKPROF afterwards ).

HTH. Michael.

In article <MPG.142f43142b2f3c47989681_at_news.baden-online.de>, TSommerfeld_at_gmx.de (Thomas Sommerfeld) wrote:
> Hi Michael,
>
> thanks for your help, but I use Oracle 8.0.6 and don't have the
> DBMS_PROFILER package. Is there a similiar function in Oracle8?
>
> Thank you
> Thomas
>
> In Artikel <8q36bs$6ho$1_at_nnrp1.deja.com> sagt michael_bialik_at_my-
deja.com
> ...
> > Hi.
> >
> > You can use DBMS_SESSION.SET_SQL_TRACE ( TRUE ); from your PL/SQL
> > code to start trace ( FALSE - to stop ).
> > With Oracle 8i you may trace PL/SQL code as well with DBMS_PROFILER
> > package.
> >
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 18 2000 - 15:41:32 CDT