| About Oracle Database Link [message #307850] |
Thu, 20 March 2008 03:11  |
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 #307861 is a reply to message #307850] |
Thu, 20 March 2008 03:35  |
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 |
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 #307871 is a reply to message #307850] |
Thu, 20 March 2008 04:01 |
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 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
