Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • catting.sh Linux/Unix
  • DBMS_UTILITY.ANALYZE_SCHEMA Oracle
  • To check whether standby is recovering properly or not?? Oracle
  • Find_table_size.sql Oracle
  • create a folder in multiple places Linux/Unix
  • moving lob object to other tablespace lob_mvmt.sql Oracle
  • PLSQL Table Syntax 2 Oracle
  • setting prompt display with .profile Linux/Unix
  • Important Script Method for tuning Oracle
  • SQL Server Vs Oracle Architecture difference SQL Server
  • CPU speed on solaris Linux/Unix
  • get_vmstat_linux Oracle
  • Set Role explaination. Oracle
  • pvm_metric.sql for gathering report from vmstat tables Oracle
  • standard Monitoring – 1 Oracle

Tag: goldengate

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 (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (150)
  • SQL scripts (350)
  • 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.sql23-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
  • Convert multiple rows to single column Oracle
  • Oracle 10g Wait Model Oracle
  • Check_recovery.sh program to run sqlplus and return its values remotely. Linux/Unix
  • sid_wise_sql.sql Further explaination Oracle
  • Formatter Explain plan Output 1 Oracle
  • Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1 Oracle
  • proper cpu stats Linux/Unix
  • chk_space_SID.ksh Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme