Quick Trace #oracle

Quick Trace.md

alter session set tracefile_identifier='MY_TRACE';
alter session set events '10053 trace name context forever';

select sysdate from dual;


alter session set events '10053 trace name context off';

connect / as sysdba


create role sql_trace;


create or replace trigger enable_sql_trace after logon on database
begin
if (dbms_session.is_role_enabled('SQL_TRACE'))
then
execute immediate 'alter session set tracefile_identifier = ''evt10046''';
execute immediate 'alter session set statistics_level = all';
execute immediate 'alter session set timed_statistics = true';
execute immediate 'alter session set max_dump_file_size = unlimited';
execute immediate 'alter session set events ''10046 trace name context forever, level 12''';
end if;
end;
/


--


grant alter session to ;


--
-- before the test
--
-- grant sql_trace to ;
--


--
-- after the test
--
-- revoke sql_trace from ;
--