keep_buffer 用起動時フルスキャントリガー

・db_keep_cache_size設定時のインスタンス起動時フルスキャン自動実行トリガーサンプル

create or replace trigger db_start_keep
after startup on database
declare
 cursor cur1 is select /*+ FULL(t) */ count(*) from TEST_TB t;
 cursor cur2 is select /*+ FULL(t) */ count(*) from TEST_TB t;
 a PLS_INTEGER;
begin
 OPEN cur1;
 FETCH cur1 INTO a; 
 CLOSE cur1;

 OPEN cur2;
 FETCH cur2 INTO a; 
 CLOSE cur2;

end;
/