| DBLiknk Performance degraded [message #139972] |
Fri, 30 September 2005 06:14  |
d.dineshkumar
Messages: 211
Registered: April 2005
Location: Kolkatta
|
Senior Member |
|
|
Hi All,
I am calling one function from one database to another database with the help of dblink.
But the problem is some days before it was working fine.
But now the function execution is taking too much time, can any one pls let me why it can be so.
Or is there any seting i have to do for the dblink.
Or Where i can look for the performance related issue with the dblink.
With Regds
Dinesh
|
|
|
|
|
|
|
|
| Re: DBLiknk Performance degraded [message #140110 is a reply to message #139972] |
Sat, 01 October 2005 00:10  |
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
|
Senior Member |
|
|
DB link performance also depends upon the network .. if the source and destination db's are at two different locations then consider the speed of the network also ..
This is rather important in your case since you said the very same function was OK last day ..
-Sai Jeedigunta
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
