Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance of queries with DB_LINKS

Re: Performance of queries with DB_LINKS

From: Frank <frankbo_at_interaccess.nl>
Date: Thu, 5 Oct 2000 10:29:23 +0200
Message-ID: <8rhe5m$m2k$1@porthos.nl.uu.net>

There's always a security hazard with public, named database links. It will allow users on db1 to view data from db2, which may not be desirable...
As for network traffic: it depends on what is done via the link; I've seen some very bad examples with views over dblinks, where a *lot* of data was retrieved in order to satisfy the view

--
Frank
NetComrade <andreyNSPAM_at_bookexchange.net> schreef in berichtnieuws
37f96703.1350481_at_news.earthlink.net...

> Hi,
>
> i know the db_links are generally a big performance killer, but if all
> dbs are on the same LAN and there isn't THAT much activity through
> them, are they still going to be a prob?
>
> Thanx.
Received on Thu Oct 05 2000 - 03:29:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US