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
|
- LOGON TRIGGER Buecherl Dieter (BUE)
- RE: LOGON TRIGGER Aponte, Tony
- logon trigger George Leonard (ZA)
- RE: logon trigger Paul . Parker
- Re: logon trigger Igor Neyman
- Re: logon trigger JOE TESTA
- Re: logon trigger paquette stephane
- Re:logon trigger dgoulet
- RE: logon trigger George Leonard (ZA)
- RE: logon trigger Vergara, Michael (TEM)
- Re: logon trigger Igor Neyman
- RE: logon trigger George Leonard (ZA)
- RE: logon trigger George Leonard (ZA)
- RE: logon trigger George Leonard (ZA)
- RE: logon trigger Ron Thomas
- RE: logon trigger Aponte, Tony