SQL Trace and TKPROF

TKPROF stands for transient kernel profiler.Enabling SQL TRACETo be able to use TKPROF, you must first enable sql trace. This can be done for either the instance or the session. If you want to change it for the entire instance, set sql_trace=true into theinit.ora file and restart the instance. However, usually, you’ll want to turn on sql trace for a particular session only. ...

Get every new post delivered to your Inbox

Join other followers: