Home » Server Options » Replication » SQLID from XID (Oracle 11.2.0.2 Goldengate 11.2.1 Linux )
SQLID from XID [message #551876] Sat, 21 April 2012 12:52
gkrishn
Messages: 491
Registered: December 2005
Location: Putty a dark screen
Senior Member

Found this warning in goldengate alert log.

2012-04-21 04:17:59  WARNING OGG-01027  Oracle GoldenGate Capture for Oracle, DB_EA.prm:  Long Running Transaction: XID 97.29.591, Items 0, Extract PDEV_EA, Redo Thread 1, SCN 2434.818157412 


Can someone tell me how to trace back transaction or sqlid from this XID number ?

Goldengate has an option to check using "showtrans" but transaction is alredy commited so this doest work.

thanks
Previous Topic: Golden gate tags
Next Topic: Oracle 8i Asynchronous replication
Goto Forum:
  


Current Time: Sun Dec 21 06:16:36 CST 2014

Total time taken to generate the page: 0.11132 seconds