• Microsoft - Oracle

    SSIS vs. Oracle GG

    April 10, 2019 - By 

    This is the third in a series of product identifications between Oracle and Microsoft to assist those attempting to understand the similarities and differences between these essential parts of any data platform environments. In this post, I’m going to describe the similarities and differences between Microsoft SQL Server Integration Services and Oracle Golden Gate. Hang on, it’s a bit of a bumpy ride. as neither service is out there on its own, (other’s piggy back off of them) and there’s definitely some new products on the Microsoft side that aren’t taken into consideration. The first thing to know is that…

  • EM13c - Oracle

    EM13c, Configuration Management and Comparing Targets

    June 6, 2016 - By 

    How many times have you had maintenance or a release complete and everyone is sure that everything’s been put back the way it should have been, all t’s crossed, all i’s dotted and then you release it to the customers only to find out that NOPE, something was forgotten in the moving parts of technology?  As the Database Administrator, you can do a bit of CYA and not be the one who has to say- Having the ability to compare targets is a powerful feature in Enterprise Manager 13c, (and 12c, don’t feel left out there…:))  The comparison feature is the…

  • ASH and AWR - AWR Warehouse - EM13c - Enterprise Manager

    Database Comparisons with AWR Warehouse- Part II, Comparison Period Report

    May 10, 2016 - By 

    There are two ways to compare one database to another in the AWR Warehouse.  I covered the ADDM Comparison Report here and now we’ll go through the second one, which is much more involved and has us empowering the AWR Warehouse taking two AWR Warehouse reports and comparing two databases to each other. The AWR Warehouse, once setup and databases that are targets already monitored by your EM12c or EM13c environment, can then be added and upload all AWR snapshots to this central repository. Comparison Period Report The AWR Warehouse second comparison reporting option is accessible from the drop down…

  • ASH and AWR - AWR Warehouse - Oracle

    Database Comparisons Using AWR Warehouse Part 1- ADDM Comparison

    May 9, 2016 - By 

    A lot of my ideas for blog posts come from questions emailed to me or asked via Twitter.  Today’s blog is no different, as I was asked by someone in the community what the best method of comparing databases using features within AWR when migrating from one host and OS to another. There is a  lot of planning that must go into a project to migrate a database to another host or consolidate to another server, but when we introduce added changes, such as a different OS, new applications, workload or other demands, these need to be taken into consideration.…