Trigger to set trace on login

[denevge]

You can use

sys.dbms_system.set_sql_trace_in_session(sid,serial#,true/false)

sid and serial# can be found in v$session using

select sid,serial#
from v$session
where audsid = userenv('sessionid');

Hope this helps
Gert