Hi all,
I am a newbie and I was hoping to find some help here.
My issue is I found a lag in my golden gate extract process. From ggserr.log I found the XID/SCN for the long running transaction. But by the time I tried to query v$transaction the transaction is finished.
Now I want to find out what the long running transaction was. So from my understanding I thought some system view or views could help me find sql_id giving the SCN/RECID. But I am not sure how. So I am here. Please help.
And trying to search for the same, I found people suggesting to use AWR report to find out. But I think AWR is based on the system views. So why use awr when I can use a simple query.
Thanks for helping