re: logon trigger

[JOE TESTA]

George here is how we did ours"   create or replace trigger olap1_logon_trigger   after logon on olap1.schema begin   execute immediate 'alter session set optimizer_mode = first_rows'; end; /   Customize it to your liking.   Joe