If a distributed query joins two tables from the same remote database, then the join may be performed by the slave session in the remote instance. If so, that join is said to be a collocated join.

We have seen oracle bugs that talk about problems with remote collocated joins. Any idea what that is?