Tracnac/Stream pool.md

Last active September 23, 2022 16:32

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Tracnac/73e637c92e2f56847ac3df0641eda4b1.js"></script>
Save Tracnac/73e637c92e2f56847ac3df0641eda4b1 to your computer and use it in GitHub Desktop.

Stream pool #oracle #sql

Raw

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

Tracnac/Stream pool.md

Select an option

No results found

Select an option

No results found