This website uses cookies to store information on your computer. Some of these cookies are used for visitor analysis, others are essential to making our site function properly and improve the user experience. By using this site, you consent to the placement of these cookies. Click Accept to consent and dismiss this message or Deny to leave this website. Read our Privacy Statement for more.
Jonathan Lewis

Reading Execution Plans - A Couple of Case Studies


Jonathan Lewis, JL Computer Consultancy


 

Abstract

This session will examine a couple of execution plans that have appeared on the Oracle Developer Community database over the last few months, explaining what information can be seen from the intial request for assistance, what further information might be needed, and what database considerations might come into play that are outside the immediate scope of the information available in a plan. There will be no Powerpoint slides in this presentation as the medium is not appropriate for displaying plans of a "real-world" complexity.

Speaker Biography

Jonathan Lewis is a well-known figure in the Oracle world with more than 30 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 1,200 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 has presented 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.