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
Jonathan Lewis Compression in Oracle – part 5: Costs of Index Compression In the previous article in this series we looked at index compression, and the way in which Oracle stored index... 27 February 2013 13 min read
Jonathan Lewis Compression in Oracle – part 4: Basic Index Compression In the first three parts (Part 1: Basic Table Compression, Part 2: Read-Only Data, Part 3: OLTP Compression) of this... 13 February 2013 13 min read
Tim Gorman What makes a DBA? What skills set the database administrator (DBA) apart from other technologists? Of the many responsibilities laid upon a DBA, which... 07 February 2013 3 min read
Jonathan Lewis Compression in Oracle – Part 3: OLTP Compression In part two of this series we examined the effect of updates on compressed data when using basic compression, and... 31 January 2013 14 min read
Neil Anderson Jonathan Lewis helps to optimize Red Gate’s Oracle tools Speed, performance, optimization: time is of the essence when you’re waiting for an operation to complete. Our Oracle tools — Schema... 28 January 2013 7 min read
Jonathan Lewis Compression in Oracle – Part 2: Read-Only Data In part one of this series we saw that the mechanics of basic table compression came in to play only... 24 January 2013 13 min read
Randolf Geist HAVING Cardinality When performing aggregate GROUP BY operations an additional filter on the aggregates can be applied using the HAVING clause. Usually aggregates are one of... 21 January 2013 2 min read
Jonathan Lewis Compression in Oracle – Part 1: Basic Table Compression In this short series on compression in Oracle, we will be looking at the various types of compression used by... 15 January 2013 12 min read
