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
Patrick Barel Virtual Private Database (Part 2) Admit that your own private Mount Everest exists. That is half the battle. – Hugh Macleod Other options In the... 04 September 2013 8 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
Steve Harville High load average, high IO wait, slow process startup, slow RAC communications We have been having performance problems on our test Exadata for several months. I have opened five Oracle service requests... 19 August 2013 2 min read
David Njoku Introduction to Instrumentation The forest is thick with menace. The sunlight barely breaks through the leaves and is sludgy like curdled milk; the... 07 August 2013 7 min read
Syed Jaffar Hussain Oracle Database 12c New Features – Part 4 Parts 1,2 & 3 focusssed more on the most useful improvements and enhancements of Database administration: Performance Tuning, RMAN, Data... 25 July 2013 6 min read
Kirill Loifman Enable Oracle database to send emails via SMTP server Often in a complex enterprise Infrastructure Oracle DBAs face issues by enabling SMTP mail traffic on the databases through corporate... 22 July 2013 1 min read
Syed Jaffar Hussain Oracle Database 12c New Features – Part 3 During this Oracle Database 12c new features article series; I shall be extensively exploring some of the miscellaneous, yet very... 11 July 2013 8 min read
Bobby Curtis Upgrade to Oracle Database 12c – Single Instance With every release of the Oracle database there is always an upgrade path that should be followed. For many, they rush... 08 July 2013 7 min read
Syed Jaffar Hussain Oracle Database 12c New Features – Part 2 During this Oracle Database 12c new features series, I shall be extensively exploring some of the miscellaneous, yet very useful,... 03 July 2013 10 min read
Syed Jaffar Hussain Oracle Database 12c New Features – Part I During this Oracle Database 12c new features article series, I shall be extensively exploring some of the very important new... 27 June 2013 10 min read
