Session Level Tracing

Overview

The following details how to collect diagnostic trace information for issues at the system and session level.

Tracing a Session

 alter session set tracefile_identifier='10046'; 
 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'; 

 -- SQL to be Traced Here 
 SELECT * FROM dual;

 exit;