{パフォーマンスの管理その他}TKPROF処理したSQLトレースを作成

 

https://docs.oracle.com/cd/F19136_01/tgsql/performing-application-tracing.html#GUID-045E1093-E389-4F2A-94CB-820AF356C564

 

ALTER SESSION SET TRACEFILE_IDENTIFIER = 'my_trace_';
alter session set sql_trace=true;
select count(*) from sh.TOKEI;
alter session set sql_trace=false;

tkprof orcl_ora_12339_my_trace_.trc orcl_ora_12339_my_trace_.txt sys=no
cat orcl_ora_12339_my_trace_.txt