SQL Performance (MOSC)

MOSC Banner

distributed transaction performances after migrating from 11g to 19c

Ciao


After upgrading two 11g databases to 19c ( with expdp/impdp and new statistics calculated with dbms_stats ) 

many queries using dblinks between the two database decreased their perfromances


queries using objects on both database works slowly

queries working on remote node only ( via dblink ) have a different behaviour and performances look good


query I used to test is accessing two joined remote tables and a local function which is a part of a package 


in 19c it seems the join between remote tables is done on local database while using 11g on remote one which is faster


i tried to exclude local function and it works fine also in 19c environment ( join is executed on remote ) 

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