| DBLinks and performance Issues [message #195302] |
Wed, 27 September 2006 18:56  |
reach_honey
Messages: 10
Registered: June 2005
Location: Boston
|
Junior Member |
|
|
Hi all,
Here is the issue.
I have a production box say DW1 which has mirror copy to stand by read only dbs p1.
I have a reporting instance R1 which points to P1 through dblink.
Now there are synonyms being created in R1 which points to P1 for all of our production tables.
Performance really sucks while running queries like that.
Is there any solution to work our on this in order to improve performance.?
Some one suggested that you can drop synonyms and create a view with dblink?
Does any one have better idea or suggestion to solve this problem
|
|
|
|
| Re: DBLinks and performance Issues [message #195312 is a reply to message #195302] |
Wed, 27 September 2006 20:32  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
Have a look at the DRIVING_SITE hint. It can encourge the execution of SQLs to occur on the remote server.
Why don't you just run the reports directly on the P1 instance?
Ross Leishman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
