12 lines
591 B
SQL
12 lines
591 B
SQL
-- trace_10046_10053_mysid_on.sql - Turn ON SQL Trace EVENT 10046 LEVEL 12 and 10053 on own Session
|
|
ALTER SESSION SET tracefile_identifier = '10046_10053';
|
|
--
|
|
COL host_name NEW_V host_name;
|
|
COL trace_file NEW_V trace_file;
|
|
COL filename NEW_V filename;
|
|
--
|
|
SELECT host_name, value trace_file, SUBSTR(value, INSTR(value, '/', -1) +1) filename FROM v$instance, v$diag_info WHERE name = 'Default Trace File';
|
|
--
|
|
ALTER SESSION SET STATISTICS_LEVEL = 'ALL';
|
|
ALTER SESSION SET EVENTS '10046 TRACE NAME CONTEXT FOREVER, LEVEL 12';
|
|
ALTER SESSION SET EVENTS '10053 TRACE NAME CONTEXT FOREVER, LEVEL 1'; |