My Oracle Support Banner

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

Last updated on SEPTEMBER 20, 2022

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.