In the last few years, GoldenGate has become the preferred choice for DBAs to handle the replication requirement of their data centers. Besides being extremely easy to configure, GoldenGate offers immense flexibility in the configuration strategies available with it. This series of articles will discuss GoldenGate technology, covering concepts, configuration options, troubleshooting and so forth. The Scenario Imagine you are… Continue Reading →

All Things Oracle Full Articles, Database Administration, Database Development

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

Database triggers. If you have spent any length of time within the Oracle development circle you might have noticed something strange: pretty much every expert – commentator, blogger, Oracle evangelist – has written an article condemning triggers. And every single time the comment section is flooded with developers/DBAs defending them. I recently joined the fray, writing an article warning against… Continue Reading →

All Things Oracle Full Articles, PL/SQL

In this article, I will demonstrate how to quickly create a standby database for a non-multitenant container database (NCDB) by plugging it as a pluggable database (PDB) into primary CDB (BOSTON). This method tremendously simplifies and speeds up the procedure to create a standby database without the need to set various initialization parameters or take backup or configure tnsnames.ora entries… Continue Reading →

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

This is the last part of my series on Execution plans, and features an option which is only available if you have licensed the Diagnostic and Performance Packs. It’s a feature that allows you to watch the flow of data through an execution plan as the query is running, typically through the graphic interface supplied by Enterprise Manager  (or Grid… Continue Reading →

All Things Oracle Full Articles, Database Administration, Database Development, Oracle Database

Feeling brave?  Enjoy danger? Well, I dare you to walk into a room full of Oracle experts wearing an I ♥ DATABASE TRIGGERS t-shirt. Let’s see if you walk out of that room alive. Database triggers are the Oracle feature that developers love to hate, perhaps above every other.  And it’s pretty unanimous – from luminaries like Tom “Triggers are… Continue Reading →

Database Development, Oracle Database, PL/SQL

In parts 11 and 12 of this series I described the “rowsource execution statistics” that we can collect as Oracle runs a query, then described a strategy for generating and accessing these statistics in a way that was particularly convenient if you could use your own session to run the SQL you wanted to analyze. In this article we’re going… Continue Reading →

11g, 12c, All Things Oracle Full Articles, Database Administration, Database Development, Oracle Database

It is probably a bad idea to define a word by using a bigger one, but I really can’t introduce the concept of overloading without briefly mentioning polymorphism. Polymorphism, in computer programming, is the ability of an object to interface in different ways depending on other, external criteria. And if that isn’t exactly clear, don’t worry about it; just know… Continue Reading →

All Things Oracle Full Articles, Database Development, PL/SQL

I use Enterprise Manager Cloud Control to mask Oracle databases so they can be shared with our ERP vendor. I intended to do the same with our legacy Informix database but I found that we did not have the Database Gateway licenses required for using Enterprise Manager Data Masking Pack on Informix. We also had a requirement to replace customer names and… Continue Reading →

Database Administration

Rolling Forward a Physical Standby Database Using the RECOVER Command A standby database is a transactionally-consistent copy of the production database. It enables production Oracle database to survive disasters and data corruption. If the production database becomes unavailable because of a planned or an unplanned outage, Data Guard can switch a standby database to the production role, minimizing the downtime associated… Continue Reading →

11g, 12c, All Things Oracle Full Articles, Database Administration, Database Development, Oracle Database, Troubleshooting