Re: Cannot Set Trace

In article <ayAL7.35954$fm5.4937811_at_typhoon.southeast.rr.com>, "Buck Turgidson" <jc_va_at_hotmail.com> wrote:

> I am trying to trace a session and it's bind variables on 8.1.6 on Linux.
>
> As sys, I "exec dbms_system.set_ev(8,37,10046,4,'')". I then go to the
> udump directory, but it is empty. I am sure that the session in question
> has had activity. I have also tried "ALTER SESSION Set SQL_TRACE = TRUE"
> from within the session I want to trace, with no luck.
>
> I am fairly certain that I am looking in the correct directory because a
> sister directory, arch, contains archived logs.
>
> Any suggestions on what to try next?

Sorry, the source code was not quite correct: Here is the correct version:

SQL> create or replace trigger scott.sql_trc   2 after logon
  3 on scott.schema
  4 begin
  5 execute immediate 'alter session set sql_trace=true';   6 end;
  7 /

Trigger created.

SQL>
$
 sqlplus scott/tiger

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Nov 23 18:37:21 2001

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production With the Partitioning option
JServer Release 8.1.7.2.0 - Production

SQL> I also failed to mention that in order to do the tracing, the target session must be connected using DEDICATED SERVER.

-- 
Mladen Gogala