If you don’t use the automatic SGA (i.e. set the
) - something I frequently do - and don’t use Streams, you probably have set the parameter
to 0 or not set it at all, since you reckon that the pool is used for Streams alone and therefore would be irrelevant in your environment wasting memory.
But did you know that the Streams Pool is not just for Streams
and it is used for other tools some of which are frequently used in almost any database environment? Take for instance, Data Pump. It uses Streams Pool, contrary to conventional wisdom. If Streams Pool is not defined, it is dynamically allocated by stealing that much memory from the buffer cache. And the size is not
reset back to zero after the demand for the pool is over. You should be aware of this lesser known
fact as it reduces the buffer cache you had allocated to the instance earlier.