TKPROF 사용하기

 

setting.sql   set linesize 1000 set pagesize 1000 set timing on alter session set "_rowsource_execution_statistics"=true; alter session set timed_statistics=true; alter session set max_dump_file_size=unlimited; alter session set tracefile_identifier='memoryvirus'; alter session set events '10046 trace name context forever, level 12';

 

query.sql   쿼리

 

tkprof.sh   tkprof $1.trc $1.prf sys=no explain=system/oracle vi $1.prf