Interpreting Parallel Execution Plans
Track
DBA & Infrasturcture
Date and time
Thursday, 20. October 2016., 11:00
Room
Hall B
Duration
45'
Parallel execution plans are harder to read than serial plans because you really need to understand the impact of the order of operation, distribution mechanisms chosen, and (in recent versions of Oracle) the timing of the generation and use of Bloom filters. In this presentation we examine the basics of how parallel execution slaves work, and the way in which this can result in a massive difference between the apparent join order of an execution plan and the actual order of rowsource generation of that plan. We learn about "Table Queues" and "Data Flow Operations" and how they help us follow the order of operation, how the different distribution method can make a dramatic difference to performance, and how we can control them if it really becomes necessary.
Lecture details
About speaker
Jonathan Lewis, author
Jonathan Lewis is a well-known figure in the Oracle world with more than 27 years experience using the software. He has published three books about Oracle - the most recent being "Oracle Core" published by Apress Nov 2011 - and contributed to three others. He has posted more than a thousand articles to his blog and contributes fairly regularly to newsgroups, forums, and User Group magazines and events around the world.Jonathan has been self-employed for most of his time in the IT industry. For the last 25 years he has specialised in short-term assignments - typically of a design, review, or trouble-shooting nature - often spending no more than two or three days on a client site to address problems . He runs seminars about using Oracle all over the world and has visited more than 50 different countries (and more than a dozen US states) to talk about, or trouble-shoot, Oracle systems, but now spends more time in the UK using Internet technology to handle remote trouble-shooting assignments.He is Oracle Ace Director and Oak Table member.
Best Sponsor
Better Sponsor
Good Sposor
University sponsor
Media Sponsor
HrOUG.hr
The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.