How to Get 10046 Trace for Parallel Query
(Doc ID 1102801.1)
Last updated on NOVEMBER 07, 2023
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle Database - Enterprise Edition - Version 8.1.5.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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/worker (QS) : Do the work and pass results back to the QC
- Parallel execution server set : Collection of QS that execute one operation
Solution
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
| Goal |
| Solution |
| Background |
| Session Tracing |
| Tracing a process after it has started |
| Tracing in 11g and higher versions |
| References |