Install SQLT
https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=g9m3m73u5_9&_afrLoop=16958946259376
sqlplus / as sysdba
SQL> create tablespace SQLT datafile '/u01/app/oracle/oradata/dsidb/sqlt01.dbf' size 50M;
SQL> create user sqlt identified by sqlt;
SQL> grant SQLT_USER_ROLE to sqlt;
SQL> start sqlt/install/sqdrop.sql
SQL> start sqlt/install/sqcreate.sql
conn scott/scott
alter session set events '10046 trace name context forever,level 12';
select count(1) from t1;
alter session set events '10046 trace name context off';
select tracefile from v$process where addr=(select paddr from v$session where sid=(select sid from v$mystat where rownum<=1));
sqlid='4usswnngj0jdx'
conn scott/scott
select sql_id,sql_text from v$sql where sql_text like '%emp%';
SQL> select sql_text from v$sql where sql_id='4usswnngj0jdx';
SQL> start sqlt/run/sqltxtract.sql 4usswnngj0jdx sqlt
sqlplus scott/scott
start sqlt/utl/coe_gen_sql_profile.sql 4usswnngj0jdx sqlt
start coe_gen_sql_profile_4usswnngj0jdx.sql