Home » RDBMS Server » Performance Tuning » About Oracle Database Link (Solaris , 10.2g)
About Oracle Database Link [message #307850] Thu, 20 March 2008 03:11 Go to next message
Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh
Member
I have created database link from database A to database B. Suppose link name A_to_B. Now I access data of database B through this link. Now in which machine load averages will increase?

Which machine sga and pga will be used for this task?
I have gone through documentation but did not find any.
Re: About Oracle Database Link [message #307856 is a reply to message #307850] Thu, 20 March 2008 03:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The answer is both for both questions. Smile

Regards
Michel
Re: About Oracle Database Link [message #307859 is a reply to message #307850] Thu, 20 March 2008 03:29 Go to previous messageGo to next message
Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh
Member
In which database execution plan and parsing is done?
Re: About Oracle Database Link [message #307861 is a reply to message #307850] Thu, 20 March 2008 03:35 Go to previous messageGo to next message
Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh
Member
Frankly, I need to minimize load from producation database. But I don't have RAC. It is under deployment. Just for now if from another database through database link I access data of production database will it improve performance?
Re: About Oracle Database Link [message #307869 is a reply to message #307861] Thu, 20 March 2008 03:52 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
No.
Accessing data across a database link is never going to be quicker than accessing it from the machine it is on.
It may well not be noticably slower, but it is never going to be quicker.
Re: About Oracle Database Link [message #307870 is a reply to message #307850] Thu, 20 March 2008 03:54 Go to previous messageGo to next message
Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh
Member
Thank Bottom much.
In which database execution plan generated and parsing is done?
Re: About Oracle Database Link [message #307871 is a reply to message #307850] Thu, 20 March 2008 04:01 Go to previous messageGo to next message
Oraclist
Messages: 33
Registered: January 2008
Location: Dhaka, Bangladesh
Member
I imagine the following scenario. Is it correct?

Query From Database A to Database B using Database Link. I wanted to depict the main points only.Is it ok?

1.Load Data in Database B machine's sga.
2.Transfer Data using Network to Machine A and load in to Machine A's sga.
3.Display data into SQL*plus of machine A.

Re: About Oracle Database Link [message #307893 is a reply to message #307870] Thu, 20 March 2008 04:50 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
In which database execution plan generated and parsing is done?

Both but plan is finally stored on the driving site.

Regards
Michel
Previous Topic: How can we write this query in a better or more efficeint way?
Next Topic: Selection of driving table
Goto Forum:
  


Current Time: Sat Dec 03 18:19:48 CST 2016

Total time taken to generate the page: 0.05124 seconds