Satishbabu Gunukula Convert Oracle Single Instance to RAC: RMAN DUPLICATE DATABASE Method Convert an Oracle single-instance non-ASM database to RAC using RMAN's DUPLICATE DATABASE feature. Part 1 covers the duplication method for... 20 September 2012 13 min read
Steve Harville Migrating a 2TB database to a new operating system with different endianness I recently moved a 2TB database from Linux, Oracle 11.1 to AIX, Oracle 11.2 using impdp with network_link and parallel... 19 September 2012 1 min read
Martin Giffy DSouza PL/SQL Exceptions Propagation during Variable Declaration It’s always good to know how any language handles and propagates exceptions, Oracle PL/SQL being no different. They’re plenty of... 11 September 2012 1 min read
Gert Poel Generating XML from SQL and PL/SQL – Part 1: Introduction From time to time you’ll have to represent your data stored in a database in an XML format, eg. to... 05 September 2012 5 min read
Patrick Barel Checking for NULL with Oracle SQL The art of doing mathematics consists in finding that special case which contains all the germs of generality. David Hilbert... 30 August 2012 7 min read
Wissem El Khlifi Data Guard Physical Standby Database Best Practices – Part 1 Oracle Data Guard is one of the software solutions provided by Oracle Corporation to maximize high availability of Oracle databases.... 07 August 2012 8 min read
Randolf Geist Oracle Cost-Based Optimizer Advanced This video and set of resources is a follow up to the webinar broadcast by Red Gate on 01 August... 02 August 2012 2 min read
Randolf Geist Incremental Partition Statistics Review Here is a summary of the findings while evaluating Incremental Partition Statistics that have been introduced in Oracle 11g. The... 01 August 2012 2 min read
Doug Burns Statistics on Partitioned Tables When Jonathan Lewis decided it was time to post a list of the Partition Stats posts on his blog and... 01 August 2012 1 min read
Patrick Barel ANSI SQL if you can’t beat them, join them. Gregory Y. Titelman Since Oracle 9i, Oracle SQL supports the ANSI SQL... 18 July 2012 6 min read
Jonathan Lewis ANSI Outer 2 A comment on a recent post of mine pointed me to a question on the OTN SQL and PL/SQL Forum where someone... 17 July 2012 1 min read
Dominic Delmolino Hate the player, not the game — or my case for Data Engineers Has “database” become a dirty word within your organization lately? If you’re someone who has been a data technologist for... 16 July 2012 4 min read
Chet Justice Fun with OBIEE SQL I posted a couple of tweets yesterday about this crazy query I had to work with. I won’t Storify you... 13 July 2012 2 min read
Doug Burns Falling in Love All Over Again: OEM 12c Performance Page Enhancements Oracle Enterprise Manager 12c introduces the latest evolutionary stage of the Performance Pages demonstrated in the previous webinar. This session... 10 July 2012 1 min read
Randolf Geist Dynamic Sampling (III) – Real-Life Data – Part II In the previous installment of this series we saw that Dynamic Sampling wasn’t of great help when dealing with certain... 05 July 2012 11 min read
Doug Burns How I Learned to Love Pictures: OEM Performance Page Fundamentals The following video and set of resources are from the webinar broadcast by Red Gate on 03 July 2012. Watch... 26 June 2012 1 min read
Randolf Geist Dynamic Sampling (III) – Real-Life Data – Part I In the previous parts of the series I outlined the basics on Dynamic Sampling. Let’s see how Dynamic Sampling deals... 20 June 2012 9 min read
Dominic Delmolino Pascal matrix SQL puzzle solution I’ve been impressed with the solutions to my little problem of generating a symmetric Pascal matrix using SQL. Charles Hooper in particular has provided... 19 June 2012 1 min read
Randolf Geist Nested Loop Join Costing The basic formula for calculating the costs of a Nested Loop Join is pretty straightforward and has been described and... 14 June 2012 2 min read
Martin Giffy DSouza SELECT INTO Techinques One thing that bothers a lot of PL/SQL developers is when they have to select some data from a table... 13 June 2012 1 min read
