Tuesday, May 3, 2016

read position and write position of GoldenGate pump process

How do we check current read position and write position of GoldenGate pump process 

GGSCI (hidb401) 60> send PTNMLDB, status

Sending STATUS request to EXTRACT PTNMLDB ...
EXTRACT PTNMLDB (PID 39845948)
  Current status: Recovery complete: At EOF

  Current read position:
  Sequence #: 6
  RBA: 1113
  Timestamp: 2016-04-04 14:14:55.000000
  Extract Trail: /oraarch/oval013t/fs01/ggs01/trails/pg

  Current write position:
  Sequence #: 0
  RBA: 0
  Timestamp: 2016-04-04 14:18:43.860423
  Extract Trail: /opt/app/t1ova1d/ggs/product/11.1.1/dirdat/pg

---Nikhil Tatineni--
---GoldenGate -- 

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...