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
David Njoku Oracle for Absolute Beginners: Part 2 – SQL A wise man* once said, no one’s ever learned how to cook just by reading recipes. And so, since we... 13 January 2014 13 min read
David Njoku Oracle for Absolute Beginners: Part 1 – Databases A wise man* once said, an expert is someone who uses big words and acronyms where simple phrases would do... 10 December 2013 8 min read
Jan Leers Error Handling Most programmers don’t like exceptions, but you should consider them as your closest friends. They are the ones that honestly... 06 December 2013 8 min read
David Njoku A Beginner’s Guide to Optimizer Hints It is often easy to forget this, but in many ways it is after we hit the execute button that... 25 November 2013 7 min read
Kirill Loifman High Availability and SLA requirements for Oracle database Designing a highly available database system involves taking various elements and combining them to suit your business needs and requirements.... 24 November 2013 1 min read
Bobby Curtis Overview of a few features in Oracle Pluggable Database 12c By now, many of us have downloaded, installed and either played with or implemented the latest release of the Oracle... 22 October 2013 6 min read
Jonathan Lewis Histograms Part 3 – When? In part 2 we looked at the way that Oracle collects and uses height –balanced histograms, and raised the problem... 16 October 2013 11 min read
Jonathan Lewis Histograms Part 2 In part 1 of this series we discussed the reasons why we might want to create some histograms to help... 01 October 2013 14 min read
Neil Anderson Protecting your changes when working in a shared environment Over the last few months, we’ve been visiting customers and helping them get up and running with Red Gate tools.... 16 September 2013 4 min read
Oracle Patrick Barel in Oracle Oracle Virtual Private Database (VPD) Part 2: Advanced Policy Options and Data Redaction (12c) Oracle Virtual Private Database (VPD) advanced policy options and Data Redaction - additional DBMS_RLS.ADD_POLICY parameters for fine-grained access control, and... 04 September 2013 9 min read
Jonathan Lewis Histograms Part 1 – Why? In this short series on histograms we will be looking at the reasons why we need histograms and the methods... 28 August 2013 15 min read
Patrick Barel Virtual Private Database (Part 1) Views When working with views you have several options to hide some of the data. In the article on views... 21 August 2013 9 min read
