Sloooow DB link
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Sloooow DB link

  1. #1
    Join Date
    Feb 2001
    Posts
    6

    Angry

    We have two instances on two different machines, both on the same local subnet (in fact, physically next to each other). We have created db links from one to the other, but they are exceptionally slow, i.e. doing sql using a local table runs orders of magnitude faster than the doing the same sql against table@dblink. The network, etc. don't appear to be the problem (same subnet, 100MB+ link between the two, etc.).

    Ignoring the network for a moment (yes, I know <g>), is there something in Oracle itself that can make a difference in how fast a database link works? Does the protocol used between the two instances matter? (right now it's TCP, but I've been told that IPC might be faster)

    Thanks,

    Vince

  2. #2
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    connections throw db-link work in sqlnet and use tcp-protocol.
    The problem may be the query you run...(don't make join throw db-link because the time on responce will be exponential in negative)....if you have problem only on select then i sugest you to encrease some buffer-parameters on your local machine (check also open_links param. on your db)

  3. #3
    Join Date
    Nov 2000
    Posts
    212
    there was(version7.2?) and may be still are some cases when oracle pumps join table from one server to another if a query has a join to remote table.
    Check for that using SQL plans and data block statistics for a query(sqlplus from 8i can do that).

Posting Permissions

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


Click Here to Expand Forum to Full Width