How to Get 10046 Trace for Parallel Query
(Doc ID 1102801.1)
Last updated on AUGUST 04, 2018
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.