Wanted to check if the below is normal in OCI.
- A query across two Databases in the "same region" thru DB link runs for about 300 ms
- the same query above when run across two Databases in "different regions" using DB link runs for about 2 seconds.
i.e. is it normal for the cross region database link performance to be almost 6 times worse than within the same region.?