Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cursor sharing implications when using database links

Charles MSep 25 2019 — edited Oct 3 2019

Hi All,

We have an Apex application running on one database - call it 'A'. Cursor sharing is set to exact on this instance. However, the Apex application does use database links to execute some SQL on a remote database - call it 'B'. Cursor sharing is set to force there. I see that views and synonyms are also being used on 'A' for these SQL's. Does anyone know that impact of having two different values for cursor_sharing would be?

DB versions: A = 12.2.0.1; B = 12.1.0.2

Regards,

Charles

This post has been answered by BPeaslandDBA on Sep 26 2019

Jump to Answer

Added on Sep 25 2019

#general-database-discussions

22 comments

606 views