{結果キャッシュ}初期化パラメータによりサーバ結果キャッシュの設定

https://docs.oracle.com/cd/F19136_01/tgdba/tuning-result-cache.html#GUID-E26C1BB2-F2A3-4FFD-93B0-B8A791017289

show parameter result

alter system set result_cache_mode = force;
alter system set result_cache_max_size = 10M;
alter system set result_cache_max_result = 2;

select * from V$RESULT_CACHE_OBJECTS;

select count(*) from sh.tokei;

alter system set result_cache_mode = manual;