sqlt

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