Database Link Question (For Guru)!

I am considering creating a database link between two production databases (Db1 and Db2).

The link will allow Db1 to interrogate certain tables on Db2.

Both Db1 and Db2 reside on different servers running Oracle 7.3 on Unix.

The question I have is, where does the loading occur when a query is executed from Db1 on Db2.

Both Db1 and Db2 are supporting business critical applications, and this is where my concerns lie.

I am keen to understand the impact on both databases and both servers if a query (or multiple simultaneous queries) are run from Db1 on Db2.

Will there be an impact on the Db2 database if queries are run on it from Db1?

What processor takes the biggest hit. Is it server1 or server2, or do both servers processors get used?

Are Unix processes kicked off on both servers if a query is executed from Db1 on Db2?

Finally, I would appreciate if anyone could advise me of any other drawbacks to creating a database link between two production databases.

Eternal thanks in advance for any help,

Japs1.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 21 2000 - 04:44:56 CDT