How to Get 10046 Trace for Parallel Query (Doc ID 1102801.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.5.0 and later
Information in this document applies to any platform.

Goal

The Note gives instruction how to gather 10046 traces for parallel queries.

For use by Developers and everyone who is interested in tuning.
It also explains where you find the generated trace files.
I assume that the reader is familiar with Parallel execution and the terminology.
Here is a short overview, more information are in the documentation.
Parallel execution coordinator/query coordinator (QC):
The user background process that controls the query.
Parallel execution servers/slave (QS);
Do the work and pass results back to the QC
Parallel execution server set:
Collection of QS that execute one operation

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