Tag Archives: oracle 11g

Loading Tables with Oracle GoldenGate and REST APIs

With Oracle GoldenGate 12c (12.3.0.1.x), you can now quickly load empty target tables with data from your source database. You could always do this in previous releases of Oracle GoldenGate, but the process has now been simplified using REST APIs and some scripting know-how. In this post, I’m going to show you, high level, how […]

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

Use DCLI to check #em12c agents on Exadata – all at once

For all the benefits of Oracle Enterprise Manager 12c (OEM), there is one draw back when using OEM with Real Application Clusters or Exadata…. checking the status of the EM Agent on each node.  When a node is bounced, some times the EM Agent does not always restart.  When this happens on a single instance […]

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

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

Find what databases you have quickly – #EM12c Inventory Search

Thought I would write a quite tip on how to find what versions of databases you have in your environment.  Oracle Enterprise Manager 12c provides a quick and easy way to find this information once it is configured within your environment.  Starting at with the Enterprise menu, you will go to Configuration and then Inventory […]

Oracle GoldenGate (Streams) process disabled – Why?

It is amazing what Oracle Enterprise Manager 12c will report once it is configured for a product.  Once such product is Oracle GoldenGate.  I have stepped into a project where I’m running Oracle GoldenGate between many different environments for production purposes.   Just trying to get a handle around what is going on has been a […]