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
Gert Poel Using Subtypes for Booleans I try to use subtypes as much as I can and after reading the “All Things Oracle” article of Patrick... 21 June 2013 5 min read
Patrick Barel Views Success always occurs in private and failure in full public view. – Unknown When working with views you have several... 05 June 2013 5 min read
Satishbabu Gunukula Oracle Database Replay for your Workload Test Database replay was introduced in Oracle 11g R1, and it allows you to capture workloads on a Production system and... 30 May 2013 8 min read
Aman Sharma RAC One Node In the past few years, technology has become a very important aspect of our lives. There isn’t any moment when we are... 25 April 2013 20 min read
Randolf Geist Analyzing and Troubleshooting Oracle Parallel Execution Watch video The video above is accompanied by the following resources: Analysing and Troubleshooting Parallel Execution presentation slides (.pdf)... 17 April 2013 1 min read
Martin Giffy DSouza Console Wrapper 1.0.4 Console Wrapper 1.0.4 is officially out. You can download it from the project page: https://code.google.com/p/js-console-wrapper/ The only change for this release... 11 April 2013 1 min read
Patrick Barel PL/SQL Subtypes Technology is dominated by two types of people: those who understand what they do not manage, and those who manage... 03 April 2013 6 min read
Doug Burns Oracle SQL Monitoring – Performance Analysis This video is a follow up to the webinar broadcast by Red Gate on 27th February 2012. Please leave a... 27 March 2013 1 min read
Nick Celis A valuable component in your APEX ECO-System When working with APEX, you also need a number of tools to improve the efficiency of your work. It isn’t... 26 March 2013 2 min read
Dominic Delmolino Bridging the Developer/DBA Divide: Advances in Database Source Control For over 10 years now, I’ve been a huge advocate of integrating database development, design and architecture practices into application... 13 March 2013 7 min read
Jan Leers Introduction to Table Partitioning Divide and conquer is what Oracle was thinking with this one. Table partitioning is about optimizing “medium selectivity queries”. The... 07 March 2013 8 min read
Satishbabu Gunukula Oracle Database Source Control made easy using Red Gate’s new tool Red Gate is launching new tool “Source Control for Oracle tool” on March 12, 2013. How this tool can help... 01 March 2013 2 min read