Oracle Golden Gate related

  • info all to list extracts/pumps/replicats running under current manager
  • info all allprocesses to list initial extracts under current manager
  • echo "info all allprocesses" | ggsci to list initial extracts under current manager

To monitor the status of the Extract/Replicat progress
  • echo "stats <repname>, total" | ggsci | grep "Total operations" 
I came across a case where there are multiple flows and I want to monitor the total progress
for i in {1..9}
do
  echo "stats <extname or repname>${i}, total" | ggsci
done | grep "Total operations" | awk '{sum+=$NF} END {print sum}'

No comments:

Post a Comment