Database Administration (MOSC)

MOSC Banner

Whats wrong with this logon trigger?

edited Jan 21, 2015 10:31AM in Database Administration (MOSC) 9 commentsAnswered ✓
Hi,
Whats wrong with this, I get error regarding row 5 (alter session)

  CREATE OR REPLACE TRIGGER SYS.set_trace 
  AFTER LOGON ON DATABASE 
  WHEN (USER like  'PETE') 
  DECLARE     
  lcommand varchar(200); 
  BEGIN     
  EXECUTE IMMEDIATE 'alter session set statistics_level=ALL';      
  EXECUTE IMMEDIATE 'alter session set max_dump_file_size=1000M';     
  EXECUTE IMMEDIATE 'alter session set events ''10046 trace name context forever, level 12'''; 
  END set_trace; 
  /

Well, trying to do this throws an error:

alter session set max_dump_file_size=50M;

ORA-02248: invalid option for ALTER SESSION


Regards
Peter

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center