SQL Reference Guide > SQL Reference Guide > SQL Statements > SET > SESSION [NO]CACHE_DYNAMIC
Was this helpful?
SESSION [NO]CACHE_DYNAMIC
SET SESSION [NO]CACHE_DYNAMIC enables or disables the caching of query plans for cursors defined with dynamic SELECT statements. It overrides the server level setting defined by the cache_dynamic configuration parameter. To check the current setting, use SELECT DBMSINFO ('CACHE_DYNAMIC').
The SET SESSION [NO]CACHE_DYNAMIC setting persists for the duration of the session.
See also [NO]CACHE_DYNAMIC.
Last modified date: 04/26/2024