Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • How to calculate PROCESSES parameter Oracle
  • TNSNAMES entries details Oracle
  • On solaris 10, “S” link is not part of $ORACLE_HOME/bin/oracle as default. ( For 9.2.0.8) Oracle
  • Reclaim temp tablespace for oracle 8, 8i Oracle
  • Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh Linux/Unix
  • EXTPROC Oracle
  • How to Decide upto what level you can decrement your datafile size. ( Shrink Datafile) Oracle
  • MYSQL and Oracle Comparison for Oracle DBA MYSQL
  • crtgr.sql /* For creating trigger from data dictionary */ Oracle
  • oracle 10g on linux Linux/Unix
  • Physical Standby switchover with session active Oracle
  • sid_wise_cursor.sql find open cursor basis on username or SID Oracle
  • get_vmstat.ksh for Solaris Oracle
  • To Find Orphan OS processes. Linux/Unix
  • Oracle Standby Database Library Index from Metalink 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

  • AMC10 (0)
  • 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 (6)
  • Videos (0)

Recent Posts

  • AMC1020-Sep-2026
  • 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

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Exadata Basics Oracle
  • DBMS_UTILITY PACKAGE Oracle
  • avail.sh ( find filesystem spae usage) Linux/Unix
  • Oracle Data Direct to TAPE Oracle
  • How to remove blank lines using vi editor command Linux/Unix
  • lck.sql Oracle
  • upload.html PHP/MYSQL/Wordpress
  • All Hints for Oracle Databases Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme