Tag Archives: 11g

Tuning with ASH Analytics in #em12c

Performance tuning of the Oracle Database has always been a great thing to learn and a valuable skill for any database administer.  In a previous post, I talked about how to use the Active Workload Repository (AWR) and Active Session History (ASH) to performance turn a database.  In this post, I want to take a […]

Combat with an enqueue wait event (enq: HW–Contention)

Recently I’ve been combating a high water mark enqueue wait (enq: HW – contention) on a single node within an Exadata I’m supporting.   I first noticed the wait when I was looking at the performance page for the node in Oracle Enterprise Manager 12c.  What I noticed was the a lot of brown looking spikes […]

Oracle JDBC Connection Tester

From time to time, when working at various sites I have to check connections to a database.  If you have been an Oracle DBA for some time, you already know that the listener has to be up and services have to be registered before you can connect from a remote host.  If the listener is […]

Yet another way to monitor Oracle GoldenGate with OEM12c

In a recent post on monitoring Oracle GoldenGate, I talked about how to configure the JAGENT to use Oracle Enterprise Manager 12c to monitor Oracle GoldenGate.  If you would like to review that post, you can find it here.  For this post, I’ll show you how you can use Metric Extensions within Oracle Enterprise Manager […]

ggMessage.dat error when running GGSCI

In configuring Golden Gate environments, I always use a separate operating system user.  This user tends to be named something along the lines of “ggate” or “gg”.  This makes it simple to identify the purpose of the user.  However, when installing Golden Gate under a different OS user, there are a few things that need […]

Unexpected entries into the SYS.AUD$

While working with a customer this week, they were testing some audit functionality on the database.  The database version being tested was Oracle 11g (11.2.0.3.5).  When the user created a table, the entry in the SYS.AUD$ is registered as a CREATE TABLE.  When the user issues a DROP TABLE, the entry for DROP TABLE is […]

Installing Oracle Golden Gate 12c (12.1.2) along side Oracle Database 12c (12.1.0.1)

With the announcement of Oracle Golden Gate 12c, there comes a few new features that everyone is going to explore.  One new feature is the new way of installing Oracle Golden Gate.  In the past, the installation was simple.  Just copy the zip/tar file to the directory you want to install it in and unzip/untar […]