Thursday, March 26, 2015

Oracle GoldenGate: SKIP LONG RUNNING TRANSACTIONS

How to skip long running transactions in goldengate ?

GGSCI> send extract ENTNEW, showtrans
Sending SHOWTRANS request to EXTRACT ENTNEW ...
Oldest redo log file necessary to restart Extract is:

Redo Log Sequence Number 6, RBA 2239791
-----------------------------------------------------------
XID: 1.8.209025
Items: 0
Extract: ENTNEW
Redo Thread: 1
Start Time: 2015-26-22:00:10:06

SCN: 0.2239791 (2239791)
Redo Seq: 6
Redo RBA: 1470

Status: Running

use following command to skip long running transaction in goldengate 
we use XID to skip transactions 


GGSCI > send extract ENTNEW, skiptrans 1.8.209025

Thank you
NIKHIL TATINENI 
Oracle in Memory _______

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