Solved

oracle dblink

Posted on 2002-05-06
7
7,123 Views
Last Modified: 2012-06-21
Hi,
How dblinks work internally? If there is one dblink and more request at one time then ,is it shared among the requests and requests are queued or mulitple instances are created one for each request?
It would be great If I could find material which says wbout oracle dblink basics, creation , usage and management.

Thanks & Regards
Alok
0
Comment
Question by:asharma2
7 Comments
 
LVL 4

Accepted Solution

by:
asimkovsky earned 25 total points
ID: 6992931
Actually, a db link is NOT a pipe or a constant direct connection from one database to another. All it does is make the local external TNS connection available to sessions internal to the database. The local database server acts as the client while the remote database acts as a server.  For each connection request, you get a separate connection, just like Oracle clients connecting to an Oracle database.

For detailed information on how to administer db links, you can check the Oracle Administrator's Guide or the Net8 Administrator's Guide.


Andrew
0
 
LVL 9

Expert Comment

by:konektor
ID: 6993119
1 db session to your database using dblink = 1 session in remote DB
0
 

Author Comment

by:asharma2
ID: 6993405
If we use dblink for any online querying So do you see any performace problem , as for each request it will have to open a new session .I will tell you where I am comig from is...I have a local DB with few load and a remote DB with lot of tables.Remote DB  is providing views to which I can query for my purpose.So I am just comparing options of either opening a JDBC connection directly to remote DB or access that through dblink through jdbc on local DB.

could you please tell me pros and cons of dblink in this regard.

Thanks & Regards
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 5

Assisted Solution

by:Bajwa
Bajwa earned 25 total points
ID: 6994116
"If we use dblink for any online querying So do you see any performace problem , as for each request
it will have to open a new session ."

Performance depends upon.

1.  How many queries?  
2.  Big queries or short queries.
3.  Queries are optimized/tuned.
4.  Database/Instance is optimized/tuned.
5.  Hardware (network,machines).


"I will tell you where I am comig from is...I have a local DB with few load and a remote DB with lot of tables.Remote DB  is providing views to which I can query for my
purpose.  So I am just comparing options of either opening a JDBC connection directly to remote DB or
access that through dblink through jdbc on local DB."

Well.. JDBC is more robust (i.e. once coded you do not need to maintain links,etc)., but there is overhead.  If there are few queries I will go for DBlink otherwise JDBC.

DBlink is easy to create.
0
 

Author Comment

by:asharma2
ID: 6995350
There can be lot of queries, as it's going to be an enquiry system.There can be 50 simultaneous queries at one time.. though all these are just select statements and there can be any number of queries in a day by a user.
What problems do you perceive when there are more number of queries in dblink?
0
 
LVL 1

Expert Comment

by:Moondancer
ID: 7096829
Please update and finalize this question.  If you need Moderator assistance to split points or otherwise help with special handling, let us know via comment here or by posting a Zero point question with this question link in the Community Support topic area.
Thank you,
Moondancer - EE Moderator
0
 
LVL 13

Expert Comment

by:anand_2000v
ID: 9204636
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
points to be split between asimkovsky and Bajwa
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

anand_2000v
EE Cleanup Volunteer
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
report returning null 21 92
help on oracle query 5 43
Oracle 10g standard edition server with 4 processors 3 52
having some issue on pl sql procedure 1 16
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now