TKPROF ED EXPLAIN PLAN
TKPROF The TKPROF program converts Oracle trace files into a more readable form. If you have a problem query you can user TKPROF to get more information. The TKProf executable is located in the ORACLE HOME/bin directory. Step: sqlplus schema/password set head off ALTER SESSION SET sql_trace = true; ALTER SESSION SET tracefile_identifier = trace_xxx; run the query to be analyzed ALTER SESSION SET sql_trace = false; cd $ORACLE_HOME/bin tkprof trace_xxx.trc trace_I_query.log EXPLAIN PLAN The EXPLAIN PLAN statement displays execution plans chosen by the Oracle optimizer for SELECT, UPDATE, INSERT, and DELETE statements. A statement’s execution plan is the sequence...