Oracle Database


In Oracle Database Releases earlier than 12c, an Automatic Storage Management (ASM) instance runs on every node in the cluster, and ASM Cluster File System (ACFS) Service on a node connects to the local ASM instance running on the same host. If the ASM instance on a node were to fail, then the shared Disk Groups and hence ACFS file… Continue Reading →

12c, All Things Oracle Full Articles

Analytic functions have been part of Oracle for a very long time now – ever since 8i back in 1999. Analytic functions are an ANSI/ISO standard, and so you’ll find that they are similarly-implemented across a number of compliant databases. (This SQL Server article on “window functions” from sister site, Simple Talk, could very well have been talking about Oracle.) Analytic… Continue Reading →

All Things Oracle Full Articles, Database Development, Oracle Database

Introduction: Integrated Replicat is a feature unique to Oracle GoldenGate 12c, for Oracle Database versions starting from Oracle 11g ( and Oracle 12c (12.1.0). Classic Capture Mode: The Oracle GoldenGate Extract process captures data changes from the Oracle redo log files or archive log files on the source database system. Integrated Capture Mode: Oracle GoldenGate Extract process works directly with… Continue Reading →

12c, All Things Oracle Full Articles

Recovery Manager (RMAN) is the preferred tool to backup and recover the Oracle Database. You can use recovery catalog or the control file of the target database for RMAN Repository, but Recovery Catalog is the preferred method as it offers several advantages over the others, like reporting operations, simple recovery in case of control file damage, and more. Generally in… Continue Reading →

11g, 12c, All Things Oracle Full Articles

Introduction For versions of Oracle 11g R2, Oracle Recovery Manager (RMAN) replicates a database to a different Oracle home and opens it with NORESET LOGS option. From Oracle 12cR1, database RMAN introduced an option called ‘NO OPEN’, which duplicates your database to a new location and keeps it in an unopened state. Using this feature we can duplicate a database… Continue Reading →

12c, Backup and Recovery

Starting with Oracle Grid Infrastructure 12c (12.1), Oracle Cloud File system (ASM Cluster File System in cluster environment ) supports database files (database version and up) in addition to general purpose files so that entire Oracle databases can be stored inside Oracle Cloud FS and can leverage the Advanced Data Services such as snapshots, tagging and auditing although replication and… Continue Reading →

12c, All Things Oracle Full Articles

In the second installment of this series we looked at individual access paths for the tables in a simple join query to highlight an important flaw in the default model that the optimizer uses for indexes. Having taken advantage of a recent enhancement that addresses that flaw we are now ready to move onto the problems that appear with the… Continue Reading →

All Things Oracle Full Articles, Oracle Database

In the first installment of this series I gave an informal description of how the optimizer would consider the possibilities when choosing an execution path for a simple two-table join between an orders table and an order_lines table that I had described. In that installment I supplied the DDL for the tables and its indexes; in this installment I’m going… Continue Reading →

All Things Oracle Full Articles, Oracle Database

This series on Oracle’s Cost Based Optimizer is aimed at the less experienced DBAs and developers to help them understand what the optimizer is trying to achieve, how it arrives at an execution plan, why it makes mistakes, and (perhaps most importantly) how to recognize the source of those mistakes and so address the resulting problems in an appropriate fashion…. Continue Reading →

All Things Oracle Full Articles, Oracle Database, Performance Tuning

Prior to oracle database 12c, the procedures for converting from single-instance databases to Real Application Clusters involved following steps: Configure the control file attributes and move control file to shared storage Make the initialization parameter file entries for cluster-enabled environments and move SPfile to shared storage Create an undo tablespace for each additional instance Create redo threads for each additional… Continue Reading →

12c, All Things Oracle Full Articles, Database Administration, Database Development, RAC