Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • perf_today.sql Oracle
  • chk_space_SID.ksh Linux/Unix
  • find_open_cur.sql Find open cursorts per session Oracle
  • Wait time tuning research Oracle
  • Ports used by Oracle Software Oracle
  • To seee semaphores and shared memory segments in Solaris Linux/Unix
  • Which environment is used by currently running process ( Very good) Linux/Unix
  • SQL_PROFILE – I explaination Oracle
  • Find total file sizes Linux/Unix
  • For Search and replace unix command. Linux/Unix
  • CPU Core related projections AWS
  • Reading config file from other folder inside class Python/PySpark
  • V$ROLLSTAT status is Full Oracle
  • fkwoind.sql fkwoindex.sql Oracle
  • normal maintenance for exp-imp and renaming table Oracle

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 $4}'`
#echo $lag
echo `date +"%m-%d-%y %T"` $lag
sleep 5
done

You can also run the above file contents in background and redirect the output to file using below command.

nohup /home/paresh/check_gg_lag.sh 1>check_gg_lagout 2>&1 &
Linux/Unix, Oracle, shell Tags:extract lag, goldengate, goldengate lag, oracle, replicat lag, tracking

Post navigation

Previous Post: Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle
Next Post: Find all users who have DML privileges

Related Posts

  • 339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle
  • grep multuple patterns Linux/Unix
  • export import with parameter file. Oracle
  • ORACLE_SID in sqlplus Oracle
  • find_du.ksh to find # of files, their sizes in current folder and its subdolder Linux/Unix
  • How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • to see when crontab is changed. Linux/Unix
  • How to Use DBMS_STATS to Move Statistics to a Different Database Oracle
  • cif crons Linux/Unix
  • Free conference number from http://www.freeconference.com Oracle
  • Drop database in Oracle 10g Oracle
  • send email from unix mailx with attachment. Linux/Unix
  • replace alphabets using sed Linux/Unix
  • Specify the Rollback segment to use in Transaction Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme