Thanks for the question.
Asked: February 09, 2019 - 5:24 am UTC
Last updated: February 19, 2019 - 5:48 am UTC
Version: 11.2.0.1.0
Viewed 1000+ times
alter system set events = '10046 trace name context forever, level 8'
create or replace trigger sys.TRACE_ALL_LOGINS after logon on XXXX.schema begin execute immediate 'alter session set tracefile_identifier = XXX'; execute immediate 'alter session set events = ''10046 trace name context forever, level 18'''; exception -- -- if something goes wrong, we still want to allow a login to proceed -- when others then null; end; /
vishnudas, February 18, 2019 - 9:46 am UTC
All of the database utilities are explained in the Utilities guide.