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
Jonathan Lewis Basics of the Cost Based Optimizer – Part 3 In the second installment of this series we looked at individual access paths for the tables in a simple join... 25 June 2015 14 min read
Jonathan Lewis Basics of the Cost Based Optimizer – Part 2 In the first installment of this series I gave an informal description of how the optimizer would consider the possibilities... 17 June 2015 15 min read
David Njoku Anatomy Of A SELECT Statement – Part 2: The Hierarchical Query Clause My wife and I just welcomed our first child to the world. No, there’s no need to congratulate me; as... 16 June 2015 5 min read
Jonathan Lewis Basics of the Cost Based Optimizer – Part 1 This series on Oracle’s Cost Based Optimizer is aimed at the less experienced DBAs and developers to help them understand... 10 June 2015 15 min read
Anju Garg Oracle Automatic Storage Management Filter Driver (Oracle ASMFD) Prior to Oracle Grid Infrastructure (GI) release 12.1.0.2, ASM Library (ASMLIB) was the only method to access storage devices by... 22 May 2015 17 min read
David Njoku Anatomy of a SELECT Statement – Part 1: The WITH Clause Come, young one. Come sit by the open fire; hold your cold hands to its warmth. Let me tell you... 11 May 2015 8 min read
Aman Sharma GoldenGate – An introduction In the last few years, GoldenGate has become the preferred choice for DBAs to handle the replication requirement of their... 30 April 2015 11 min read
Anju Garg Oracle Multitenant: Convert single instance PDB to RAC by plugging it into a RAC CDB Prior to oracle database 12c, the procedures for converting from single-instance databases to Real Application Clusters involved following steps: Configure... 22 April 2015 11 min read
David Njoku In Defence of Triggers Database triggers. If you have spent any length of time within the Oracle development circle you might have noticed something... 15 April 2015 5 min read
Anju Garg Oracle Multitenant : Super-fast Provisioning of Standby Databases In this article, I will demonstrate how to quickly create a standby database for a non-multitenant container database (NCDB) by... 07 April 2015 8 min read
