You are going over a database link. I would look at where the join is happening, locally or remotely. Also, two-phase commit may be slowing some operations down. Check http://download-west.oracle.com/docs...a76960/toc.htm for details.