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. ...

Optimizing queries with SQL Hints

/*+ hint */ /*+ hint(argument) */ /*+ hint(argument-1 argument-2) */ All hints except /*+ rule */ cause the CBO to be used. Therefore, it is good practise to analyze the underlying tables if hints are used (or the query is fully hinted. There should be no schema names in hints. Hints must use aliases if alias names are used for table ...

Get every new post delivered to your Inbox

Join other followers: