How To Set A Trace On A Connected Session

BACKGROUND & OVERVIEW

The following code enables the tracing of a connected session.

The output gets sent to the user_dump_dest.

SCRIPT

  • Log on to the database as SYS.
exec sys.dbms_system.set_ev(sid, serial#,10046, <level_between_1_and_12>, ' ');
© copyright 2001-2014 ABCdba.com | all rights reserved