Oracle Aman Sharma in Oracle Oracle Parent and Child Cursors: The Library Cache Sharing Model, Soft Parse Deep Dive, and Cursor Version Count Diagnostics Oracle parent and child cursors explained - how the library cache shares SQL execution plans across identical statements while maintaining... 12 December 2016 11 min read
David Njoku JSON For Absolute Beginners: Part 4 – Retrieving JSON in Oracle There’s a possibility you’ve parachuted into this series on JSON and Oracle at this point. If you are already familiar... 03 October 2016 11 min read
Oracle Aman Sharma in Oracle Oracle SQL Query Parsing: Hard Parse vs Soft Parse, Cursor Caching, Library Cache, and Query Transformation Oracle SQL query parsing explained - the query processing workflow from SQL statement to execution plan, the difference between hard... 05 September 2016 16 min read
David Njoku XQuery for Absolute Beginners: Part 3 – FLWOR This is the third instalment in a series of articles that I’m hoping will serve as a primer for Oracle... 21 March 2016 9 min read
David Njoku XQuery for Absolute Beginners: Part 2 – XQuery and the Oracle Database In this series of articles I’m hoping to provide a primer for newish Oracle developers who are curious about XQuery... 02 March 2016 7 min read
David Njoku Introduction to Analytic Functions (Part 2) In the first part of this series I introduced you to the analytic functions family, outlined its close relationship to... 17 September 2015 7 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
Randolf Geist Parallel Execution Skew – Addressing Skew Using Manual Rewrites In this part of the series we will have a look at different approaches to how Parallel Execution Skew can... 23 June 2014 13 min read
David Njoku Oracle for Absolute Beginners: Part 7 – Creating Tables, Constraints and Triggers A wise man once said: start at the beginning and go on till you come to the end: then stop.... 10 June 2014 9 min read
David Njoku Oracle for Absolute Beginners: Part 6 – Procedures and Functions A wise man once said, insanity is doing the same thing over and over again but expecting different results. If... 07 May 2014 13 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
Oracle Patrick Barel in Oracle Oracle Virtual Private Database (VPD) Part 2: Advanced Policy Options and Data Redaction (12c) Oracle Virtual Private Database (VPD) advanced policy options and Data Redaction - additional DBMS_RLS.ADD_POLICY parameters for fine-grained access control, and... 04 September 2013 9 min read
Michael Sorens TortoiseSVN and Subversion Cookbook Part 11: Subversion and Oracle It is only recently that the tools have existed to make source-control easy for database developers. Although entire build-scripts for... 03 April 2013 17 min read
Richard Morris Kohsuke Kawaguchi: Geek of the Week Jenkins, formerly called Hudson, is an open-source server-based Continuous Integration tool that works with all the major Source Control Management... 17 July 2012 11 min read
Patrick Barel Working with Table Functions in PL/SQL Table functions are functions that produce a collection or rows (either a nested table or a varray) that can be... 20 July 2011 2 min read
David Njoku Readying your Oracle Database for Your First Apex Application APEX can be a great way to create an application rapidly on an Oracle Database. Although it is generally straightforward,... 14 June 2011 9 min read
Bruce Armstrong Product Review: Schema Compare for Oracle One of the more important tasks in the process of rolling out incremental developments to a multi-server production system is... 23 July 2010 11 min read
Richard Morris Tom Kyte: Geek of the Week Tom Kyte's contribution to the AskTom column and site over ten years has been outstanding. Much of what he says... 24 June 2010 20 min read
Jonathan Lewis Oracle to SQL Server, Crossing the Great Divide, Part 3 We soon learn, in SQL Server, that heaps are a bad thing, without necessarily understanding how or why. Jonathan Lewis... 23 June 2010 15 min read
Tim Gorman Bad CaRMa From hope and euphoria, to desperation, firings and the ultimate demise of a company. Tim Gorman charts the rise and... 16 October 2006 33 min read
