| Presentation Title: | Tracing PX Slaves |
| Speaker: | Mr Doug Burns |
| Company: | Independent |
| Co-presenter: | |
| Presentation abstract: | How does the anatomy of a parallel query differ from the serial equivalent? This presentation will take a single parallel query and walk-through the tracing process and resulting trace files. As well as showing how to analyse your own parallel queries using Oracle 10g features, this will illustrate the anatomy of the query and various expected and more unusual wait events. This is not an introductory presentation, so a basic appreciation of parallel execution will be assumed, although links will be provided to basic supporting information. |
| Presentation begins: | 14/11/2006 14:45 |
| Presentation duration: | 45 |
| Presentation content level: | 1 (1 = indepth, 5 = strategic overview) |
| Audience experience: | Advanced (3+ years) |
| Audience function: | |
| Speaker biography: | I have been an Oracle DBA, developer and trainer for the past 16 years. Previously, I taught Oracle courses for both Oracle UK and Learning Tree International including both application and server tuning courses.
I have presented a number of papers at user group conferences and SIG meetings. |
| Related topics: | Server Technology: Server Technology & DBA Topics |
| Hall: | 6 |
