How to use Oracle 10046 tracking events

1. Turn on 10046 trace events

Alter session SET Events ' 10046 Trace name Context forever, Level 12 ';

If you want to make it easier to identify the trace file, you can set the trace's identity before opening the event

Alter session set tracefile_identifier= ' YBB ';

When this is done, the trace file name is added YBB

2. Execute the SQL statement to be traced (there is SQL execution in the corresponding trace file)

SELECT * from dba_users where username= ' SCOTT ';

3. Stop 10046 Event Tracking

Alter session SET Events ' 10046 Trace name context off ';

4. Locate the trace file for this build

SELECT DISTINCT (M.SID), p.pid,p.tracefile from V$mystat m,v$session s,v$process p where m.sid=s.sid and s.paddr=p.addr;

5. Format the file output with the Tkprof tool

How to use Oracle 10046 tracking events