Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • crtgr.sql /* For creating trigger from data dictionary */ Oracle
  • Jai Shree Ram Oracle
  • Gathering statistics with DBMS_STATS Oracle
  • How to choose Driver table in SQL statement Oracle
  • RAC 11g with vmware Oracle
  • Does DBMS_JOB recompute the NEXT_DATE interval after or before Oracle
  • usnsql.sql Displays information about UNDO segments with sql statements Oracle
  • Import and export statements Oracle
  • prepfiles.sh for step by step generating pending statistics files Oracle
  • lck.sql Oracle
  • Global Unique Identifier Generation in Oracle 9.2 SYS_GUID() Oracle
  • 10g oem configuration Oracle
  • Jai Shree Ram PHP/MYSQL/Wordpress
  • Find nth max and min. Oracle
  • SQL_PROFILE – I explaination Oracle

Tag: goldengate 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
  • Order by with ROWNUM Oracle
  • Useful Solaris Commands on 28-SEP-2005 Linux/Unix
  • To find all disk io ( EMC as well as local) Linux/Unix
  • Rename Tablespace Oracle
  • Set Role explaination. Oracle
  • SAN Linux/Unix
  • Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
  • rm_backup_arch_file.ksh Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme