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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Advice for dblinks between two prod DBs.

Re: Advice for dblinks between two prod DBs.

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Wed, 22 Nov 2006 09:09:23 -0400
Message-ID: <cd4305c10611220509h612b5814rb30446cb9f584e6@mail.gmail.com>


Hi Rich
As you know the optimizer don't optimize as well through dblinks, if you are thinking to do complex queries, I suggestion you to use a materialized view (in the source database) or a function table (in the source database), so you only get rows from there; there is the driving site hint, if I remember well, but this didn't helped too much in the past. Another problem is when some one change the password the dblnk in the other database uses.
There is a secuiryt issue about a sys table where you can see the dblinks password.
There are several options if you check the sql reference, I suggest you to make some test I really I'm not sure which will be better for you dblink setup.

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 22 2006 - 07:09:23 CST

Original text of this message

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