Jonathan Lewis Execution Plans Part 13: SQL Trace In parts 11 and 12 of this series I described the “rowsource execution statistics” that we can collect as Oracle... 11 March 2015 12 min read
David Njoku Oracle Programming Basics: Overloading It is probably a bad idea to define a word by using a bigger one, but I really can’t introduce... 02 March 2015 5 min read
Steve Harville Data Masking using SQL Loader I use Enterprise Manager Cloud Control to mask Oracle databases so they can be shared with our ERP vendor. I intended to... 25 February 2015 5 min read
Anju Garg 12c Dataguard : Recover from Service Rolling Forward a Physical Standby Database Using the RECOVER Command A standby database is a transactionally-consistent copy of the production... 17 February 2015 13 min read
Satishbabu Gunukula Oracle Database 12c – RMAN New Features: Part 3 Oracle Database 12c has new enhancements and additions in Recovery Manager (RMAN). The Recovery Manager continues to enhance and extend... 02 February 2015 8 min read
Jonathan Lewis Execution Plans Part 12: Cardinality Feedback In the previous instalment of this series I introduced three ways of accessing the run-time statistics for a query and... 13 January 2015 13 min read
Jonathan Lewis Execution Plans Part 11: Actuals So far in this series we’ve talked about interpreting the shape of an execution plan and understanding the meaning of... 17 December 2014 13 min read
Satishbabu Gunukula Oracle Database 12c – RMAN New Features: Part 2 Oracle Database 12c has new enhancements and additions to Recovery Manager (RMAN). The Recovery Manager continues to enhance and extend... 01 December 2014 7 min read
Patrick Barel Collections in 12c Sometimes the best way to see the familiar is to go far from it – Wisdom of the desert In... 21 October 2014 9 min read
David Njoku External Tables: An Introduction At its most basic level, Oracle databases are built around data based within tables held within the database, and the... 16 October 2014 7 min read
Houri Index design: discard and sort Designing an index is not done through “trial and error”. This kind of strategy seems to doom many engineered indexes... 10 October 2014 17 min read
Satishbabu Gunukula Oracle Database 12c – RMAN New Features: Part1 Oracle Database 12c has new enhancements and additions in Recovery Manager (RMAN). The Recovery Manager continues to enhance and extend... 29 September 2014 8 min read
David Njoku Introduction to Oracle Password Verification and Complexity Function Security is in the news again. It seems there’s no greater click-bait than a story about indecent photos of beautiful... 16 September 2014 5 min read
Jonathan Lewis Execution Plans Part 10: Guesswork In part 9 we saw an example of a simple nested loop join where the basic method for interpreting the... 09 September 2014 9 min read
Jonathan Lewis Execution Plans Part 9: Multiplication In part 8 we looked at a very simple execution plan involving a hash join; but that example was too... 29 August 2014 7 min read
Satishbabu Gunukula Should you install or clone Oracle Home? What is cloning? Cloning is a process of copying an existing installation to a different server or location. Cloning is... 20 August 2014 11 min read
Jonathan Lewis Execution Plans Part 8: Cost, time, etc. It’s time to move away from the shape of an execution plan and turn our attention to some of the... 19 August 2014 11 min read
Randolf Geist Parallel Execution Skew – Skew Caused By Outer Joins In the final part of this series I want to cover one last source of Parallel Execution Skew: Skew caused... 23 July 2014 6 min read
Jonathan Lewis Execution Plans Part 7: Query Blocks and Inline Views When we examine an execution plan, we’re usually trying to work out the mechanical steps that Oracle took to produce... 09 July 2014 10 min read
David Njoku Oracle for Absolute Beginners: Part 8 – Database Design and Normalization A wise man once said, I know one thing: that I know nothing. If you’ve followed this series from the... 27 June 2014 7 min read
