CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

doubt about: trigger, trace

edited Feb 25, 2014 10:36AM in CNC, DB and Operating System - JDE1 (MOSC) 2 commentsAnswered
Hi,

1_somebody to helpme on: trace?

2_I need to create the trigger:

how to do so?

create or replace trigger logon_trigger

after logon on database
begin
if (user = 'USU1' ) then
execute immediate 'ALTER SESSION SET TRACEFILE_IDENTIFIER=''USU1_APP''';
execute immediate 'alter session set timed_statistics=true';
execute immediate 'ALTER SESSION SET EVENTS ''10046 TRACE NAME CONTEXT FOREVER, LEVEL 12''';
end if;
exception
when others then
null;
end;
end;

3_how todo with sqldeveloper?

this apply all dba user:USU1?, if yes so how to apply only 1 user jdeID?

great thanks!

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