If you don’t use the automatic SGA (i.e. set the
sga_target=0) - something I frequently do - and don’t use Streams, you probably have set the parameter
streams_pool_size 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.
