TKPROF 사용하기

안드레날린 2013. 5. 14. 19:39

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