Quick Search:
Oracle PL/SQL Code Library
Find Or Post Oracle Jobs
Oracle Discussion & Chat
 Oracle PL/SQL: TKPROF (transient kernel profiler) Jump to:  
Category: >> Oracle PL/SQL >> TKPROF (transient kernel profiler) Bookmark and Share

<< lastnext >>

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;

Oracle Magazine
and Oracle White Papers

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.

Click here to find out more
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 65 users online    © 2009 psoug.org

Forgot your password?