8. SQL Statements : SET : [No]Cache_dynamic
 
Share this page                  
[No]Cache_dynamic
SET [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 [NO]CACHE_DYNAMIC setting persists until the DBMS Server is shut down.
See also SET SESSION [NO]CACHE_DYNAMIC (see page Session [No]Cache_Dynamic).