Tracing Sql Queries.
Sign in

Tracing sql Queries.

Tracing sql queires to understand performance issues.

 

alter session set tracefile_identifier='<file_name>';
alter session set timed_statistics = true;
alter session set statistics_level=all;
alter session set max_dump_file_size = unlimited;
alter session set events '10046 trace name context forever,level 12';

 

 

This will create two files in the udump directory with extension <file_name>.trm and <file_name>.trc

start_blog_img