Hi all.
I come from an Oracle background. I understand that if we are running a
long running query on the standby and the table is dropped on master, the
XLOG replay will be delayed.
I would like to understand why is this not happening in Oracle Active
Dataguard setup. I'm guessing because of the 'C' in ACID, that conflicting
query on master is being kept in the UNDO log of the slave until the long
running query is over.
I will probably run this test on my laptop this week when I get the chance.
But does anyone know the reason?
Thanks in advance.
Cheers.