SQL>
SQL> set echo on
SQL>
SQL>
SQL> create or replace trigger logon_trigger
2 after logon on database
3 begin
4 if ( user = 'YourName' ) then
5 execute immediate
6 'ALTER SESSION SET EVENTS ''10046 TRACE NAME CONTEXT FOREVER, LEVEL 4''';
7 end if;
8 end;
9 /
Trigger created.
SQL>
SQL>
SQL> --