Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance of queries with DB_LINKS
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...Received on Thu Oct 05 2000 - 03:29:23 CDT
> 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.
![]() |
![]() |