Saturday, June 25, 2016

Skip transaction GoldenGate replicat 12c

syntax for skipping transaction #
ggsci> start replicat skiptransaction 

GGSCI (red.gg.ora.com) 14> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EDELTA      00:00:09      00:00:09    
REPLICAT    ABENDED     RMOTS       00:11:15      00:14:08    

GGSCI (red.gg.ora.com) 15> start rmots skiptransaction
Sending START request to MANAGER ...
REPLICAT RMOTS starting

GGSCI (red.gg.ora.com) 16> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
EXTRACT     RUNNING     EDELTA      00:00:09      00:00:05    
REPLICAT    RUNNING     RMOTS       00:14:41      00:00:01    

GGSCI (red.gg.ora.com) 17> stats rmots  
Sending STATS request to REPLICAT RMOTS ...

Start of Statistics at 2016-06-25 01:01:43.
Replicating from DELTA.GG_NEW to MOTS.GG_NEW:

*** Total statistics since 2016-06-25 01:00:31 ***
Total inserts                              1.00
Total updates                              0.00
Total deletes                              0.00
Total discards                             0.00
Total operations                           1.00

*** Daily statistics since 2016-06-25 01:00:31 ***
Total inserts                              1.00
Total updates                              0.00
Total deletes                              0.00
Total discards                             0.00
Total operations                           1.00

*** Hourly statistics since 2016-06-25 01:00:31 ***
Total inserts                              1.00
Total updates                              0.00
Total deletes                              0.00
Total discards                             0.00
Total operations                           1.00

*** Latest statistics since 2016-06-25 01:00:31 ***
Total inserts                              1.00
Total updates                              0.00
Total deletes                              0.00
Total discards                             0.00
Total operations                           1.00
End of Statistics.

--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...