| DB link problem [message #273903] |
Fri, 12 October 2007 03:14  |
milind_sri
Messages: 70
Registered: February 2005
Location: Pune
|
Member |
|
|
Hi Gurus,
I am facing a typical problem. I dont know what to do but as a DBA I have to suggest something.
The problem goes like this I have a script which is creating a view and firing a select query on a remote table using a db link. I dont have the access to the database, so I am not sure what to suggest in this scenario. Actually, other queries and scripts are working absolutely fine but this script is taking about 2 hours to execute.
The suggestions that I am putting in are :=
1. Drop and recreate the DB link.
2. Update the statistics of the table that is used in the select.
3. Send us the explain plan.
4. Use DRIVING_SITE hint.
Can you guys please suggest me some more on this that can help me in this scenario. Actually this is the client database that I dont have access to and I have to suggest them the resolution.
Please send your suggestions as soon as possible.
Thanks in Advance.
Milind.
|
|
|
|
|
|
| Re: DB link problem [message #273914 is a reply to message #273903] |
Fri, 12 October 2007 04:07  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
1) will achieve nothing.
2) Is always good advice
3) What you need to look at is the explain plan that the query in your script is executing
4) Depends on what the result from 3) is.
|
|
|
|
|
|
| Re: DB link problem [message #274016 is a reply to message #274015] |
Fri, 12 October 2007 13:44 |
 |
Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
And YOU know what is best for OraFAQ and its members?
Maybe you just don't understand my answer.
If you think my post is not correct, please use "Report message to a moderator" link, don't use topic body for this.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
