Tag Archives: oracle database

Oracle Golden Gate 12c (12.1.2) released – Finally!!!!

Back in June, Oracle released Oracle Database 12c and everyone went nuts trying to download and start documenting the many new features.  One of the items within the 12c (database) release that I was curious about was how is Oracle Golden Gate going to work with multi-tenant databases.  As I was testing I noticed that […]

Add database to Oracle Restart

With Oracle Real Application Clusters the Oracle database can be configured to restart as each node in the cluster is restarted.  For single instance databases that are on a standalone server, often times the database is not configured to restart on a server bounce.  In the past, Oracle recommended to set the database for restart […]

golden gate monitoring–command line

Over the last few years I’ve been working with Oracle Golden Gate (OGG) and the one thing that is an interesting topic with OGG is what is the best way to monitor the environment.  To be honest, there are a few different ways to monitor OGG; yet the simplest is from the command line.  (Yea, […]

CPU vs Waits Timing – Simple View

I’ve spent the last week performance tuning for a customer here in Georgia. The biggest thing I found was that they were having a lot of wait issues.  To illustrate these wait issues in a simplified method, I used the V$SYSMETRIC view.  The query below gives you a comparison between waits and cpu times with […]

Shutdown/Startup vs. Alter Statement – 12c Edition

When everyone finally moves to Oracle pluggable databases, one thing to remember is that stopping and starting a database is not going to be as simple as it use to be.  Shutting down and starting up a database is done simply with the following commands: shutdown normal shutdown immediate shutdown abort startup startup nomount startup […]

Change COMMON_USER prefix – 12c Edition

Earlier I wrote a post on the difference between COMMON_USERS and LOCAL_USERS within the Oracle Database 12c architecture.  I mentioned in that post that the COMMON_USER had to be configured with a C## or c## to identify the user as a common user.  This got me to thinking, what if I wanted to use a […]

Identity Columns – 12c edition

Oracle has made it easier to define unique table columns with IDENTITY columns.  These are table columns that have been enhanced to support the American National Standards (ANSI) SQL key word IDENTITY.  These columns are meant to provide a standards based approach to declaring automatically incrementing columns which will simplify application development and making the […]