the question is pretty straightforward, - when I chance to change setting in oracle gateway to microsoft sql server (dg4msql) configuration (HS_FDS_CONNECT_INFO) to another database on the same server, the database link does not always gets refreshed - sometimes new selects using that database link stay hooked to the old setting. probably oracle gateway caches the connection settings in some way? how do I clear the cache? thanks
Database links are kept open for the duration of a session. The gateway makes use of a database link so it is logical to state that if you change a gateway config, in order for it to be activated, you need to re-open the link.
Easiest is to stop and start the sessions but this can also be done by issuing an
alter system close database link linkname
See Closing Database Links in the docu.