SQL Performance (MOSC)

MOSC Banner

Slow DBlink Update query

edited Oct 8, 2016 5:00AM in SQL Performance (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center