How to Get 10046 Trace for Parallel Query
Last updated on FEBRUARY 01, 2017
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms