Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Monitor Long Running Job Oracle
  • get_vmstat_solaris Oracle
  • Find nth max and min. Oracle
  • find_arc.sql Oracle
  • Creating a Container Database using dbaascli Uncategorized
  • lck.sql Oracle
  • Kernel Parameters for Solaris Linux/Unix
  • Default User Profile Oracle
  • pvm_pre_change.sql Oracle
  • UNderstand and eliminate Latch contention. 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
  • DBMS_UTILITY PACKAGE Oracle
  • Oracle 10g Installation/Applying Patches Tips Oracle
  • Oracle Identifiers Oracle
  • 272332.1 CRS 10g Diagnostic Collection Guide 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 (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
  • move_arch_files.ksh Linux/Unix
  • arch_configUOCIOTTO.ora Oracle
  • usnsql.sql Displays information about UNDO segments with sql statements Oracle
  • Trace a SQL session from another session using ORADEBUG Oracle
  • Jai Shree Ram Oracle
  • find_log_switch.sql Find log switches in graphical manner Oracle
  • Rename Tablespace Oracle
  • New OFA for 11g Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme