where do i give the alter session command in the startup

[kollisri]

Hi,
i want to issue an alter session command at the start up of the database instance or when i connect to a user i want to run a particular alter session command,in which file i should write the alter sesion command so that whenever i login as a user that command gets executed automatically.

thanks
kolli

[marist89]

Use a logon trigger:

CREATE OR REPLACE TRIGGER logon_trigger
AFTER LOGON ON DATABASE
BEGIN
   IF (USER='JEFFH') THEN
      EXECUTE IMMEDIATE 'alter session set events ''1046 trace name context forever, level 4''';
   END IF;
END;