Slow DBlink Update query
Hi ,
Oracle Version : 11.2.0.4.0
I have an Update query which accesses remote DB for a select query.It is running forever and have to kill every time.Below is the query and plan.This query is waiting for 'SQL*Net message from dblink'.I have tried creating a view in remote DB based on select query and fetched from view@dblink.Still performance is slow.Kindly assist.
UPDATE DTL_INVOICE_LINES set
viol_prev_invoiced =
CASE
WHEN viol_sr_unmatched = 1 -- need data from enrichment or this rule will always fail
THEN null
WHEN id in
(select id from dtl_invoice_lines curr_inv