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

David Njoku

Introduction to Analytic Functions (Part 1)

Analytic functions have been part of Oracle for a very long time now – ever since 8i back in 1999....

07 September 2015 10 min read

Anju Garg

TSPITR Using ACFS Snapshots

Starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster File System in cluster environment) supports database...

10 August 2015 16 min read

Anju Garg

Integrating ACFS Snapshots With RMAN

In my last article, I demonstrated that starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster...

14 July 2015 10 min read

Jonathan Lewis

Basics of the Cost Based Optimizer – Part 4

In the first three installments of this series I outlined the mechanisms used by Oracle to analyze a very simple...

09 July 2015 14 min read

Satishbabu Gunukula

Why Virtual Private Catalog?

Recovery Manager (RMAN) is the preferred tool to backup and recover the Oracle Database. You can use recovery catalog or...

08 July 2015 8 min read

David Njoku

Anatomy Of A SELECT Statement – Part 3: Recursive Subquery Factoring

We need a baritone voiceover man. You know how those huge TV shows – 24, Prison Break, Jane the Virgin...

07 July 2015 7 min read

Ravi Kumar

Upgrading A Database Using Recovery Manager (RMAN) Duplicate Command In Oracle 12c

Introduction For versions of Oracle 11g R2, Oracle Recovery Manager (RMAN) replicates a database to a different Oracle home and...

03 July 2015 12 min read

Anju Garg

12c: Database Backups Using ACFS Snapshots

Starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster File System in cluster environment ) supports...

29 June 2015 11 min read