This content has been marked as final. Show 5 replies
Do you have any more information about the problem?
- How many rows are you deleting?
- Are you referencing local tables as well as remote tables? Are you referencing multiple remote tables?
- Can you quantify "very slow"? For example, does deleting a single row take 1 second? 10 seconds? 10 minutes?
- What is the query plan?
There are any number of potential explanations-- without more information, though, it is tough to do more than grasp at straws.
user522961 wrote:I am sure that if you scour Metalink, you will find at least one bug that involves a database link and a DELETE statement on whatever version of Oracle you are using (10g might mean 10.1.0.2 or 10.2.0.4 or anything in between). It is relatively unlikely, however, that you are actually hitting a bug. It is substantially more likely that you are encountering the far more common situation of a complex system not behaving the way you would want, in which case the information I asked for will help narrow down the source of the problem. Distributed DML is always extremely difficult for the optimizer to handle, so any performance issues that involve distributed queries make me suspect that the optimizer has made a poor decision.
Thank you justin.
We can have more information from client but the question is that if there is any known bug on DELETE via DBLINK in ORACLE 10g.