Re: sql_trace parameter

This "feature" was restored in Oracle7 7.3 release.

doug.

In article <4i6jk6$f63_at_lserv1.paging.mot.com>, Vikram Goel <vgoel_at_pts.mot.com> wrote:
>Terry,
>
>The trace file will not indicate syntax errors for you. The trace file is
>for the determination of resource usage. However if you want to set
>trace on at the instance level add sql_trace=TRUE in the init<sid>.ora
>file. If on a session level issue the command alter session sql_trace true;
>This should be the first statement in sqlplus.
>
>There are some third party products that can do syntax checking for you.
>Hope this helps,
>
>--
>Vikram Goel Motorola email: vgoel_at_pts.mot.com
>Sr. Oracle DBA - Consultant
>Aerotek Inc. My email: vgoel_at_emi.net
>
>Motorola Info:
>Mail Stop 39, Room S1014
>1500 Gateway Blvd,
>Boynton Beach, FL 33426
>
>Terry.Harding_at_CONNECTCORP.COM (Terry Harding) wrote:
>>Hi all,
>>
>>I am trying to get oracle 7.1 to trace any sql statements i send to it.
>>ex. Place the sql statements to the trace file indicating where the syntax
>>errors are located for debugging.
>>
>>Does anyone have any suggestions.
>>
>>Thanks in advance.
>>
>>Terry.Harding_at_Connectcorp.com
>>
Received on Thu Mar 14 1996 - 00:00:00 CET