How To Use The New 11g Events++ Syntax For Easier SQL Tracing Of Datapump Operations? (Doc ID 813737.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Oct-2013***

Goal

As of Oracle11g, a new event syntax has been introduced, which makes it easier to perform tracing of processes. This can be used especially for environments such as Datapump, where multiple processes are started and the lifetime of these processes is volatile.

Up to now, in order to e.g. enable 10046 level 12 tracing for the Datapump processes, one had to obtain the session IDs or OS process IDs of the various Datapump processes, and then use methods like ORADEBUG or DBMS_SYSTEM.SET_EV() to enable the tracing for each process individually.

With the new Events++ syntax, you no longer need to know the session or process ID's of the individual processes, but can quickly and easily enable e.g. 10046 level 12 trace for the processes based on their short names.

The trace files generated are located in the Advanced Diagnostics Repository (ADR).
Next command shows the location of the tracefile(s):

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms