Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • how to find VIP from ifconfig Linux/Unix
  • Process Map for CPU and Memory for OS processes Linux/Unix
  • Trace a SQL session from another session using ORADEBUG Oracle
  • Good notes for shared pool Oracle
  • scripts to take listener.log backup Linux/Unix
  • TABLE SIZING WITH DB_BLOCK ARCHITECTURE Reference : Metalink note : 10640.1 Oracle
  • Set Role explaination. Oracle
  • on IBM-AIX for display Linux/Unix
  • pvmehta.com SQL scripts
    Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle
  • Example of How To Resize the Online Redo Logfiles Note:1035935.6 Oracle
  • Good Link from metalink 1 Oracle
  • In Addition to previous note, following grants needed on PERFSTAT user. Oracle
  • online_bkup.sql Oracle
  • Jai Shree Ram Oracle
  • Goldengate Tutorial Oracle

Tag: extract 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
  • Alter procedure auditing Oracle
  • 284785.1 How to check RAC Option is currently linked into the Oracle Binary Oracle
  • runon_allpdbs_show_conname.sh Oracle
  • Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1 Oracle
  • Complete Git Tutorial for Beginners GIT
  • Vivek Tuning for Row Locks. Oracle
  • arch_configUOCIOTTO.ora Oracle
  • Good notes for shared pool Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme