Home » RDBMS Server » Server Administration » Database links
Database links [message #381906] Tue, 20 January 2009 04:27 Go to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member
Hello,

I would like to know whether there are ways of administering dblinks? If yes, please what are they.

Thanks in advance.
Re: Database links [message #381920 is a reply to message #381906] Tue, 20 January 2009 05:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Define "administering".

Regards
Michel
Re: Database links [message #381931 is a reply to message #381920] Tue, 20 January 2009 06:00 Go to previous messageGo to next message
abdulaziz
Messages: 102
Registered: May 2008
Location: Douala
Senior Member

ayayaye Embarassed -simple your answer Michel, but it says it all Smile -

Well, uhmm, what I mean is,does setting up dblinks between databases affect say, the performance of the databases or the schema that owns the dblink and how to increase security on public dblinks? The doc that I have do not dwell on those subject.
Re: Database links [message #381934 is a reply to message #381931] Tue, 20 January 2009 06:10 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Does it affect database performances, yes when you access it you obviously load the network and queries are often less performant over a db link.

Does it affect security, yes you open a door to the remote database, so take care with which user you connect to.

Regards
Michel
Previous Topic: ORA-12500: TNS:listener failed to start a dedicated server [merged]
Next Topic: archivelog sequencing
Goto Forum:
  


Current Time: Mon Dec 05 08:32:01 CST 2016

Total time taken to generate the page: 0.16208 seconds