Hi Gurus,
I am running replication from my primary to my standby via a replication server. I found that my DSI thread keeps dying because the locks on the standby have been exceeded by a particular transaction. I then increased this from 25000 to 150000 and resumed the thread, but still it seems a transaction is using all the locks and crashing my DSI thread. This transaction worked on my primary, why is it not going thru on my standby? I also have tried locating this transaction/procedure which is running against my standby, but no luck.
How do I find out which is the current transaction in my standby?
I am running replication from my primary to my standby via a replication server. I found that my DSI thread keeps dying because the locks on the standby have been exceeded by a particular transaction. I then increased this from 25000 to 150000 and resumed the thread, but still it seems a transaction is using all the locks and crashing my DSI thread. This transaction worked on my primary, why is it not going thru on my standby? I also have tried locating this transaction/procedure which is running against my standby, but no luck.
How do I find out which is the current transaction in my standby?