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 Session [No]Cache_Dynamic).