Blogs >> Technology >>
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
|