I used this trigger in 8i to do some tracing on a unix db and it has wroked but for some reason in 9i it doesnt work.
I wanted to trace a specific user's whose session id I cannot figure out due to to the fact that it the process connects and disconnects often..
CREATE OR REPLACE TRIGGER LOG_TRIGGER AFTER
LOGON ON DATABASE begin
if user = 'OPS$KFOO' then
execute immediate 'alter session set sql_Trace=true';