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?

Try creating a database trigger, something like this:

CREATE OR REPLACE TRIGGER SQL_TRC
AFTER LOGON
ON SCOTT.SCHEMA
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE=TRUE'; END;
/

You'll need to be logged in as a DBA, with 'CREATE ANY TRIGGER' system privilege. This thingy works on oracle 8.1.7

-- 
Mladen Gogala