{パフォーマンスの管理その他}シーケンスを共有プールに固定

 

https://docs.oracle.com/cd/F19136_01/tgdba/tuning-shared-pool-and-large-pool.html#GUID-E0D415CA-C4A7-4588-ADF2-4E302CE25849

create sequence sh.seq1 start with 1 increment by 1;

select sh.seq1.nextval from dual;

begin
DBMS_SHARED_POOL.KEEP (
   name =>'SH.SEQ1', 
   flag =>'Q' );
end;
/

select * from v$db_object_cache 
where kept = 'YES'
and type = 'SEQUENCE'
;

begin
DBMS_SHARED_POOL.UNKEEP (
   name =>'SH.SEQ1', 
   flag =>'Q' );
end;
/

select * from v$db_object_cache 
where kept = 'YES'
and type = 'SEQUENCE'
;