DB_LINK QUESTION

Hi there. I was hoping that I could get some feedback on the following problem:

1. Two seperate Oracle Instances (Inst A; Inst B)
2. User logs onto A and does an update on a table.
3. Update trigger on table calls a remote procedure that resides on B.
4. The procedure on B performs an update on some local tables.

Here is what I would like to know. The initial update takes about 1 min to complete, while subsequent updates afterwards complete almost instantly. If however, I log off of Instance A, and update again, the first update again takes a long time, while the following updates are much faster.

I have noticed that prior to the initial update, there is no db_link with B. Once the initial update is complete, I have noticed that the db_link between A and B remains. I believe that the reason why the first update takes so long is because the db_link must be established. Is this true??? If so, are there any ways in which I can speed up the db_link connection?

Regards,
Andy
ango_at_talisman-energy.com Received on Tue Oct 08 1996 - 00:00:00 CEST