Top 60 Oracle Blogs

Recent comments

dbvisit Replicate

Dbvisit replicate – SQL Developer chart

Here is a quick SQL Developer report which display a chart about the Dbvisit replicate lag over the last hours

The idea is to have the following chart showing the lag in MINE and APPLY processes. Here is an example where I stopped the replication to show some lag.

The query is on the DBVREP.DBRSCOMMON_LAG_STATS on the APPLY side, which display the wallclock time with timestamp from the MINE and from the APPLY.

Here is the SQL Developer report .xml:

(near)Zero Downtime Upgrades for Oracle 11g/12c — Introduction and Options

So, now that I have completed my series on  OpenLDAP for Oracle Net Service Name resolution, my next little adventure will be exploring the possibilities of zero downtime upgrades for Oracle 11gR2 and 12cR1.  This is an area that I don’t have a lot of experience with, so, I’ll be pretty much starting at ground zero.