Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • sid_wise_cursor.sql find open cursor basis on username or SID Oracle
  • How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
  • New OFA for 11g Oracle
  • Btee and Bitmap Plans in Oracle 9i and higher Oracle
  • Find All internal Parameters Oracle
  • Committing distributed transaction using commit force Oracle
  • Check Oracle installed products using one command Oracle
  • To Find Orphan OS processes. Linux/Unix
  • currwait.sql Oracle
  • ORACLE_SID in sqlplus Oracle
  • ORA-00064: object is too large to allocate on this O/S during startup Oracle
  • Database link password in user_db_links Oracle
  • Korn Shell Arithmatic Linux/Unix
  • standard Monitoring – 1 Oracle
  • Useful Solaris Commands on 28-SEP-2005 Linux/Unix

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 (149)
  • MYSQL (5)
  • Oracle (400)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (348)
  • SQL Server (6)
  • Uncategorized (3)
  • Videos (0)

Recent Posts

  • 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
  • Creating a Container Database using dbaascli08-Apr-2026
  • track_autoupgrade_copy_progress.sql01-Apr-2026
  • refre.sql for multitenant01-Apr-2026
  • prepfiles.sh for step by step generating pending statistics files10-Mar-2026
  • tracksqltime.sql05-Mar-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • replace alphabets using sed Linux/Unix
  • Find sort details from Db find_sort.sql Oracle
  • telnet listening Linux/Unix
  • Giving Grant on v$DATABASE Oracle
  • Building Our Own Namespaces with “Create Context” Oracle
  • Nice Article about semaphores and init.ora Processes parameter relations Linux/Unix
  • shr1.sql for MTS or Shared server configuration Oracle
  • How to collect CPU usage on Linux using Shell script Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme