Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • FGA Part-I Oracle
  • v$event_name Oracle
  • standard Monitoring – 1 Oracle
  • RMAN : Consistent Backup, Restore and Recovery using RMAN Oracle
  • pvm_metric.sql for gathering report from vmstat tables Oracle
  • OEM-Commnds Oracle
  • All About Trace Fils Oracle
  • eplan.sql Oracle
  • initUOCIOTTO.ora Oracle
  • Creating never expiring DB user accounts in Oracle Oracle
  • pvm_rbs1.sql (to collect rbs info from db) Oracle
  • To Find Orphan OS processes. Linux/Unix
  • This is im telling Kishore Oracle
  • Read CSV File using Python Python/PySpark
  • JSON/XML Types in Oracle Oracle

Tag: replicat lag

Oracle GoldenGate lag monitoring shell script

Posted on 12-Jun-202318-Jun-2023 By Admin No Comments on Oracle GoldenGate lag monitoring shell script

Following script will be useful for tracking Oracle GoldenGate replicat process and related lag. This script will generate output on standard screen.  You can redirect it using file redirection to logfile or other locations.  while true do <goldengate home directory>/ggsci <<EOF > test.out info all exit EOF lag=`cat test.out | grep TESTREPLICAT | awk ‘{print…

Read More “Oracle GoldenGate lag monitoring shell script” »

Linux/Unix, Oracle, shell

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • find_string_in_database.sql Oracle
  • How to see which patches are applied. Oracle
  • default permission on ~/.ssh/authorized_keys2 or authorized_keys Linux/Unix
  • Important Script Method for tuning Oracle
  • v$event_name Oracle
  • get_aix_vmstat.ksh Oracle
  • AWR settings- MMON is not taking snapshot. Oracle
  • _B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme