Home » RDBMS Server » Performance Tuning » DBLinks and performance Issues
DBLinks and performance Issues [message #195302] Wed, 27 September 2006 18:56 Go to next message
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 Go to previous message
Messages: 3724
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
Previous Topic: Help on First_Rows
Next Topic: performance graph report
Goto Forum:

Current Time: Fri Oct 21 19:08:40 CDT 2016

Total time taken to generate the page: 0.08364 seconds