Re: Newbie: Optimizer and Forms4
From: Pawel Michalak <michalak_at_mimuw.edu.pl>
Date: 21 Feb 95 17:14:16 GMT
Message-ID: <3id718$gf7_at_ghost.mimuw.edu.pl>
Date: 21 Feb 95 17:14:16 GMT
Message-ID: <3id718$gf7_at_ghost.mimuw.edu.pl>
In article <1995Feb13.163642.1_at_beach.utmb.edu>, cfischer_at_beach.utmb.edu writes:
> I tried ALTER SESSION SET SQL_TRACE = TRUE but it didn't
> like it at all. I haven't been able to find anywhere in the Forms manuals about
> it either. I'm using Forms4 for windows with a 7.0 database.
Try command:
dbms_session.set_sql_trace(true);
instead.
Package dbms_session has to be installed before.
Alter session ... is a DDL command and you cannot use it in PL/SQL.
Also, you can modify initXXXX.ora (adding SQL_TRACE=true) file and
restart your instance.
But this will trace all sessions.
Regards,
Pawel Michalak.
Received on Tue Feb 21 1995 - 18:14:16 CET