OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Database links

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database links [message #381906]

Tue, 20 January 2009 04:27

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.

Report message to a moderator

Re: Database links [message #381920 is a reply to message #381906]

Tue, 20 January 2009 05:15

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Define "administering".

Regards
Michel

Report message to a moderator

Re: Database links [message #381931 is a reply to message #381920]

Tue, 20 January 2009 06:00

abdulaziz
Messages: 102
Registered: May 2008
Location: Douala

Senior Member

ayayaye

-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.

Report message to a moderator

Re: Database links [message #381934 is a reply to message #381931]

Tue, 20 January 2009 06:10

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 15:44:46 CST 2024