This content has been marked as final. Show 3 replies
Thanks for the prompt reply!
But in general, should total memory allocated for "streams pool" in SGASTAT show 6GB in total or should it be something else?
If you just want to confirm that your streams_pool_size is correct, I would suggest you to use:
select * from v$sgainfo;
show parameter streams_pool_size
v$sgastat has rows like 'free memory' (and most probably others rows...) that you can't add up all together.