Randolf Geist Parallel Execution Skew – Addressing Skew Using Manual Rewrites In this part of the series we will have a look at different approaches to how Parallel Execution Skew can... 23 June 2014 13 min read
Jonathan Lewis Execution Plans Part 6: Pushed Subqueries In part 5 of this series we examined a couple of examples where you had to handle the “first child... 16 June 2014 10 min read
David Njoku Oracle for Absolute Beginners: Part 7 – Creating Tables, Constraints and Triggers A wise man once said: start at the beginning and go on till you come to the end: then stop.... 10 June 2014 9 min read
Jonathan Lewis Execution Plans part 5: First Child Variations I’ve offered up “first child first, recursive descent” as a basic strategy for interpreting execution plans – but it’s not... 28 May 2014 14 min read
Randolf Geist Parallel Execution Skew – 12c Hybrid Hash Distribution With Skew Detection Since Parallel Execution Skew is a common problem that can severely limit the scalability of Parallel Execution (see my previous... 19 May 2014 9 min read
Jonathan Lewis Execution Plans Part 4: Precision and Timing In part 3 of this series we used a simple hash join to introduce the a simple guideline for reading... 14 May 2014 12 min read
David Njoku Oracle for Absolute Beginners: Part 6 – Procedures and Functions A wise man once said, insanity is doing the same thing over and over again but expecting different results. If... 07 May 2014 13 min read
Houri SPM Plan: non reproducibility circumstances and CBO interaction 1. Introduction When a critical report which used to complete very quickly starts performing poorly, there is a big chance... 01 May 2014 17 min read
Jonathan Lewis Execution Plans Part 3: “The Rule” In the first two articles in this series we listed a couple of methods for generating or retrieving execution plans... 25 April 2014 13 min read
Syed Jaffar Hussain How is data security maintained and what’s new in Oracle 12c database security – Part 1 Securing enterprise business-critical data is as important for DBAs as database tuning and data protection. Oracle provides comprehensive and powerful... 16 April 2014 5 min read
Randolf Geist Parallel Execution Skew – Demonstrating Skew After providing a baseline for Parallel Execution working as expected in the introduction of this series, in this part I’ll... 14 April 2014 8 min read
David Njoku Oracle for Absolute Beginners: Part 5 – PL/SQL A wise man* once said, all software programming is about hoops and loops. You take some variables, give them hoops... 07 April 2014 13 min read
Jonathan Lewis Execution Plans Part 2: Things to see In part 1 of this series we saw two basic ways of creating, or acquiring, execution plans. The first method... 26 March 2014 12 min read
Randolf Geist Parallel Execution Skew – Introduction This is the first part of a mini-series about Parallel Execution Skew and how to address it. Introduction So what... 18 March 2014 10 min read
Jonathan Lewis Execution Plans: Part 1 Finding plans If you have to tackle performance problems in an Oracle database one of the most important skills you need to... 12 March 2014 14 min read
David Njoku Oracle for Absolute Beginners: Part 4 – Multi-table queries Part 1, Part 2, Part 3 A wise man* once said: To build the Great Wall of China, you must... 03 March 2014 10 min read
Syed Jaffar Hussain Gaining maximum benefits from Oracle Data Guard When Oracle initially introduced the standby database concepts, the solo intention was to deliver the solutions to protect enterprise critical... 26 February 2014 6 min read
David Njoku Oracle for Absolute Beginners: Part 3 – Update, Insert, Delete Part 1, Part 2. A wise man* once said: So no-one told you life was gonna be this way. Your... 13 February 2014 10 min read
Patrick Barel Result Cache (Part 2) Insanity: doing the same thing over and over again and expecting different results. – Albert Einstein In part 1 we... 04 February 2014 5 min read
Patrick Barel Result Cache (Part 1) First, solve the problem. Then, write the code. – John Johnson We are always looking for ways to do things... 28 January 2014 5 min read
