SQL: Generating Trace Files

Oracle Database Server trace files can be generated at the session or instance level.

• Instance level tracing can be enabled using SQL_TRACE init.ora parameter

• Session level tracing  for a particular session can be enabled as :

               sql> Execute dbms_system. set_sql_trace_in_session(x, y, TRUE);
                      --Here x is the system identifier and y is the serial number

• Session level tracing for the connected user:

              sql>alter session set sql_trace=TRUE; Trace files can be obtained from USER_DUMP_DEST directory