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: 482
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 19 20:11:37 CDT 2013

Total time taken to generate the page: 0.32573 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.