Description: TKPROF stands for "transient kernel profiler". TKPROF is one of the most useful utilities available to DBAs for diagnosing performance issues. It essentially formats a trace file into a more readable format for performance analysis.
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 the init.ora file and restart the instance. However, usually, you'll want to turn on sql trace for a particular session only.
The trace files will be written into the directory pointed to by the parameter user_dump_dest. You can query for the value with select value from v$parameter where name = 'user_dump_dest'.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 07th, 2009
ALTER session SET sql_trace=TRUE;-- or, from another session with a
sys.dbms_system.set_sql_trace_in_session(session's id,serial number, true)
-- include timing information. Set the timed_statistics parameter
-- to true or issue one of these commands:
alter system set timed_statistics=true;
alter session set timed_statistics=true;
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.