Re: Trace SQL commands in PL/SQL

From: Michael Bialik <michael_bialik_at_my-deja.com>
Date: Sun, 17 Sep 2000 19:34:21 GMT
Message-ID: <8q36bs$6ho$1@nnrp1.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.

HTH. Michael.

In article <MPG.142f2698d27f1834989680_at_news.baden-online.de>, TSommerfeld_at_gmx.de (Thomas Sommerfeld) wrote:
> Hi,
>
> is there any possibility to trace single SQL commands in a PL/SQL
> procedure with measuring the needed CPU time (like the normal Oracle
> trace)?
>
> Thanx
> Thomas
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Sep 17 2000 - 14:34:21 CDT