EXECUTE DBMS_MONITOR.SESSION_TRACE_ENABLE(session_id => 19, serial_num => 2689, waits => true, binds => true, plan_stat=>'ALL_EXECUTIONS');
ALTER SESSION SET TIMED_STATISTICS=TRUE; ALTER SESSION SET MAX_DUMP_FILE_SIZE=UNLIMITED; ALTER SESSION SET TRACEFILE_IDENTIFIER='SQLTRACE'; ALTER SESSION SET EVENTS 'sql_trace wait=true,bind=true,plan_stat=adaptive'; -- ★
ALTER SESSION SET EVENTS 'sql_trace off';
ALTER SYSTEM SET EVENTS 'sql_trace [sql:f4bp1uungguxb] wait=true,bind=true,plan_stat=adaptive';
ALTER SYSTEM SET EVENTS 'sql_trace [sql:f4bp1uungguxb] off';
CREATE OR REPLACE TRIGGER logon_sqltr AFTER LOGON ON SCHEMA BEGIN EXECUTE IMMEDIATE 'ALTER SESSION SET TIMED_STATISTICS=TRUE'; EXECUTE IMMEDIATE 'ALTER SESSION SET EVENTS ''sql_trace wait=true,bind=true,plan_stat=adaptive'' '; EXECUTE IMMEDIATE 'ALTER SESSION SET TRACEFILE_IDENTIFIER=''SQLTRACE'' '; EXECUTE IMMEDIATE 'ALTER SESSION SET MAX_DUMP_FILE_SIZE=UNLIMITED'; END; /
CREATE OR REPLACE TRIGGER logoff_sqltr BEFORE LOGOFF ON SCHEMA BEGIN EXECUTE IMMEDIATE 'ALTER SESSION SET EVENTS ''10046 TRACE NAME CONTEXT OFF'' '; END; /
ALTER TRIGGER logon_sqltr DISABLE ALTER TRIGGER logoff_sqltr DISABLE
select value from v$diag_info where name = 'Diag Trace';
# $ORACLE_HOME/bin/tkprof <SQLトレースファイル> <出力ファイル名>