Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Finding locked objects Oracle
  • Shuffle an array PHP/MYSQL/Wordpress
  • To check whether standby is recovering properly or not?? Oracle
  • In Addition to previous note, following grants needed on PERFSTAT user. Oracle
  • Rownum with Order by Oracle
  • Find all users who have DML privileges Oracle
  • Changing the Global Database Name Oracle
  • track_autoupgrade_copy_progress.sql Oracle
  • process id based files and processes Linux/Unix
  • Good Oracle Architecture In Short and point to point Oracle
  • Korn Shell Arithmatic Linux/Unix
  • Oracle 11g Environment Setup Oracle
  • eplan9i.sql Oracle
  • get_vmstat_solaris Oracle
  • compile_inv.sql 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

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (5)
  • Videos (0)

Recent Posts

  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026
  • find_arc.sql09-Apr-2026
  • pvm_pre_change.sql08-Apr-2026
  • find_encr_wallet.sql08-Apr-2026
  • find_pdbs.sql08-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • find_longsql.sql Oracle
  • Jai Shree Ram Oracle
  • Reclaim temp tablespace for oracle 8, 8i Oracle
  • avail.sh ( find filesystem spae usage) Linux/Unix
  • Exadata Basics Oracle
  • How does one overcome the Unix 2 Gig file limit? Linux/Unix
  • Privilege to describe the table. Oracle
  • Changing the Global Database Name Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme