Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    18

    Red face Unanswered: Oracle Database Link Performance Question

    Hi,

    I have used the database link to compare the records between Database A and B before perform deletion of records in Database A. To have better performance, should the script connect to database A then call database link to database B or the opposite way? Appreciate advice from the expert here. Thanks a lot.

  2. #2
    Join Date
    Mar 2004
    Location
    India
    Posts
    87
    Database Link performance is dependent on the network and not of the database. More high speed the interconnect between the databases is, better will be the db link performance whichever way you may operate.

  3. #3
    Join Date
    Oct 2003
    Posts
    18
    Hi MePreeti,

    Do you know any sites which talk about the database link performance issue? If yes, appreciate if you could let me know. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •