Tag Archives: database

Counting the many rows of Oracle GoldenGate

******NOTICE****** !The code contained in this post is meant to be  used at your own risk! ******NOTICE******  With any Oracle GoldenGate replication configuration, it is always good to monitor what is going on.  One aspect that many people want to know is how can I validate that every record is being transferred to the target […]

Performance Tuning with AWR & ASH in #em12c

Oracle monitoring and performance tuning has grown over the years.  With every release of the Oracle database the monitoring capabilities that have been provided have evolved.  In Oracle11g, monitoring with statpack has given way to Automatic Workload Repository (AWR) and Active Session History (ASH) for near real time monitoring of items within the Oracle database.  […]

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 […]

Database Machine (EXADATA) Schematic problem in OEM12c

When adding an Exadata to Oracle Enterprise Manager 12c (OEM), it is pretty easy yet at times you may run into a problem or two.  Many of these problems can be minimized by using the Oracle Enterprise Manager 12c: Exadata Discovery Cookbook (cookbook).  The cookbook can be found here, so you don’t have to search […]

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 […]

Oracle Restart with Oracle Database 12c (12.1.0.1)

Back in October, I wrote a blog post on adding an Oracle 11g Database to Oracle Restart to help start the database on a server reboot (if you want to read that post, you can find it here).    Since my original post on using Oracle Restart to start a database, I’ve talked with a few […]

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 […]