Anju Garg Oracle Database 12.1.0.2c: Automatic Big Table Cache Serial direct path reads were first introduced in Oracle 11g to prevent wiping out a large number of buffers from... 11 March 2016 18 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
Kartik Balachandran Siebel CRM Part 2: Initial Upgrade and Setup of an Amazon Instance A Siebel CRM upgrade project typically consists of numerous iterations even before the actual development and bug fixes take effect.... 22 February 2016 22 min read
Kartik Balachandran Siebel CRM Part 1: Should I Upgrade or Re-implement? As of the most recent Forrester Wave Report for Customer Relationship Management applications, Oracle’s Siebel CRM is still quite a... 18 February 2016 7 min read
Jonathan Lewis Massive Deletes – Part 2 In Part 1 of this short series I provided an informal description of a couple of scenarios where we might... 17 February 2016 15 min read
Anju Garg ASM Proxy: New Instance Type in Oracle 12c Prior to Oracle Database 12c, an ASM instance ran on every node in the cluster and ASM Cluster File System... 15 February 2016 11 min read
Jonathan Lewis Massive Deletes – Part1 In a recent article about dropping columns from a table I left hanging the question of what you might do... 29 January 2016 12 min read
Houri 12c Hybrid histogram In the previous article about the Oracle 12c TOP-Frequency histogram, we saw that Oracle carries out a preliminary determination step... 26 January 2016 20 min read
Houri 12c Histogram: TOP-Frequency As of Oracle version 12.1, if a number of buckets N in a histogram is less than the number of... 19 January 2016 13 min read
Jonathan Lewis Dropping Columns I have my Oracle Support account configured to send me a daily email of “hot topics”, and I’ve set it... 14 January 2016 13 min read
Anju Garg Split Brain: What’s new in Oracle Database 12.1.0.2c? In an Oracle cluster prior to version 12.1.0.2c, when a split brain problem occurs, the node with lowest node number... 14 January 2016 10 min read
Anju Garg Oracle Data Pump in RAC Oracle Data Pump was introduced in Oracle Database 10g to enable very high-speed transfer of data and metadata between databases.... 10 December 2015 15 min read
David Njoku SQLcl: The new challenger for the SQL Plus crown I’m that grumpy old guy who comes to your party and sits in a corner with a face like a... 30 November 2015 9 min read
Gert Poel About functions, records and result cache This article is about functions and how to get more out of them if you combine them with record structures.... 20 November 2015 6 min read
David Njoku Multi-Table Insert Statements in Oracle We all know this: if a long-bearded prophet came down from a mountaintop bearing the ten commandments of Oracle programming,... 09 November 2015 7 min read
Jonathan Lewis Basics of the Cost Based Optimizer – part 6 In part 5 of this series I started working through a list of queries designed to demonstrate ways in which... 04 November 2015 14 min read
Jonathan Lewis Basics of the Cost Based Optimizer – Part 5 It’s been three months since I last published anything in this series on the Cost Based Optimizer, so a thumbnail... 30 October 2015 17 min read
David Njoku Introduction to User-Defined Aggregate Functions OK, let’s speed past the easy bits, the parts we all already know: standard aggregate functions. Aggregate functions, unlike regular... 30 September 2015 7 min read
Anju Garg Oracle 12c Cluster: ACFS Leverages Flex ASM In Oracle Database Releases earlier than 12c, an Automatic Storage Management (ASM) instance runs on every node in the cluster,... 30 September 2015 10 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
