Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • OPENING A STANDBY DATABASE IN READ-ONLY MODE Oracle
  • Read CSV File using Python Python/PySpark
  • All About Trace Fils Oracle
  • My Minimum Tuning Programs Oracle
  • Renaming Oracle Instance Name Oracle
  • chk_space_SID.ksh Linux/Unix
  • VIvek Encryption Package and Its Usage Oracle
  • Convert multiple rows to single column Oracle
  • Implementing Listener Security Oracle
  • export import with parameter file. Oracle
  • To seee semaphores and shared memory segments in Solaris Linux/Unix
  • How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle
  • T-SQL Vs PL/SQL Syntax SQL Server
  • Very Good Oralce Internal Tuning Book Oracle
  • mutex in Oracle 10.2.0.2 or Oracle 10g 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 (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (342)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • Complete Git Tutorial for Beginners25-Dec-2025
  • Postgres DB user and OS user.25-Dec-2025
  • Trace a SQL session from another session using ORADEBUG30-Sep-2025
  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Load SPM baseline from AWR Oracle
  • Oracle10g – Using SQLAccess Advisor (DBMS_ADVISOR) with the Automatic Workload Repository Oracle
  • SQL_PLAN.sql for checking real execution plan Oracle
  • Finding Oracle Patches with opatch Oracle
  • Changing unix system clock when Oracle database is running. Oracle
  • To check whether standby is recovering properly or not?? Oracle
  • SQLPLUS COPY command Precautions. Oracle
  • How to Make Trace Files Created by Oracle Readable by All Users ? Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme