The Arup Nanda Blog: Streams Pool is only for Streams? Think Again!
The streams pool isn't only used for streams. It's also used by the following.
- Data Pump
The streams pool will be dynamically allocated, defaulting to 10% of the shared pool size, and stealing from the buffer cache.
So... what else uses the streams pool ? We have a 11.2.0.3 database where the streams pool is dynamically allocated on startup by "something". That "something" is the same process as identified by this log message, identified in the session trace by an sqlplus session.
Alert Log
- [30114] Successfully onlined Undo Tablespace 2.
Session Trace
- *** MODULE NAME:(sqlplus ...
