alter system set "_disable_streams_pool_auto_tuning"=TRUE;Vérification :
select * from v$sgastat where pool ='streams pool';
col "Hidden Parameter" form a30
col "Parameter Value" form a20
select ksppinm as "Hidden Parameter",
ksppstvl as "Parameter Value"
from x$ksppi join x$ksppcv using (indx)
where regexp_like(ksppinm, '__streams_pool_size');Référence : http://www.orafaq.com/forum/t/203820/ https://support.oracle.com/knowledge/Oracle%20Database%20Products/1596645_1.html