TruTek

Seminar overview

Oracle Database’s partitioning options can be used for help in three areas: VLDB information lifecycle manageability, data availability and performance. This seminar will mostly cover partitioning for performance, how to design partitioning for performance and how to write/troubleshoot SQL which should use partitioning for performance.
 
The second part of this section will cover parallel execution internals, tuning and troubleshooting, both in partitioned and non-partitioned environments and we also touch the topic of configuring parallel execution right on RAC.

Seminar Duration and Details
Seminar duration:                             1 day
Audience:                                        Senior DBAs, senior developers, database designers
Skill level:                                        Intermediate to Advanced

You will learn the following…
·       Best practices for partitioning (in different circumstances) and how to avoid common pitfalls
·       How to control partition pruning and measure whether desired partition pruning is happening
·       How to achieve serial partition wise joins for joining large datasets
·       Understand how the parallel execution engine and row distribution works
·       Best practices for parallelism (in different circumstances) and how to avoid common pitfalls
·       How to troubleshoot Parallel execution plans and see exactly where the bottleneck is

Table of contents

Designing applications and databases with partitioning in mind

• Designing for partition pruning
• Designing for serial Partition wise joins
• Choosing between local vs. global indexes
• Partitioned objects, CBO and optimizer statistics collection

Troubleshooting partition pruning

• Measuring which exact partitions are visited during the SQL execution
• Why isn’t the desired partition pruning happening?

Understanding data flow in parallel execution plans

• Understanding producer-consumer hierarchy
• Monitoring data distribution and table queues

Achieving optimal data distribution in parallel execution plans

• Avoiding data broadcasts and many-to-many distribution
• Combining multiple rowsource operators onto a single level in parallel execution hierarchy
• Parallel partition-wise joins
• Best PX distribution for partitioned tables
• Parallel execution considerations in RAC

Advanced Parallel Execution Troubleshooting

• Tracing parallel execution and gathering detailed parallel execution stats
• Monitoring IO throughput and detecting IO subsystem saturation

Customer Feedback About Tanel:

Our recent exercise with Tanel Poder was an extremely positive one and one which I would recommend to anyone seeking help with a contention issue on their Oracle database.  I had seen Tanel speak at the Hotsos Conference in Dallas and knew that he would be extremely valuable in helping us identify what was causing an unpredictable latching scenario in our production environment. 

Even before he arrived he asked for and begin reviewing the data we had collected (AWR reports, statspack output, etc.) and begin devising a "plan of attack" for determining the cause of our issue.  Upon arrival he took our input very seriously,  but was quick to validate our assumptions with factual database analysis.  I also appreciated his concern for our security and the well-being of our production environments and was very careful to not run scripts which would cause contention themselves in production, or leave behind bothersome custom objects.  

Tanel was always courteous and friendly and was willing to repeat his explanations and translate his very technical knowledge into terms that the lesser-trained DBA could comprehend.  And the tools he brought along were bundled up nicely for us to download to our own environment and use for our troubleshooting.  He summarized his findings for us in a way that was presentable to upper management and gave a clear explanation of his approach, analysis, and final recommendations.

I appreciated Tanel's offer to be a resource in the future if we have further questions after using his scripts and tools and I fully intend to take him up on it!    

Not finding the course or date that you're looking for? Let us know!