Snippet Name: TKPROF (transient kernel profiler)
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'.
Comment: (none)
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;
-- or
alter session set timed_statistics=true;
|
