Database Administration (MOSC)

MOSC Banner

Creating DB links

edited Mar 12, 2010 2:01AM in Database Administration (MOSC) 8 commentsAnswered
 Hi All,
I created two db links as below

1) create database link db1 connect to user1 identified by user1 using 'hostip:portno/servicename';

2) create database link db2 connect to user2 identified by user2 using 'db2_server';

From the above the second link created using a tnsname db2_server.

My question is in performance point of view which performs better?

Regards,
Subbu

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center