Cause
A database feature which needs STREAMS SGA was being used, however, the streams_pool_size parameter was not defined and the value of db_cache_size was too small to permit an automatic transfer of SGA to the streams pool from the buffer cache.
A database feature which needs STREAMS SGA was being used, however, the streams_pool_size parameter was not defined and the value of db_cache_size was too small to permit an automatic transfer of SGA to the streams pool from the buffer cache.
Please set the parameter streams_pool_size or set SGA_TARGET.
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e0.htm
http://docs.oracle.com/cd/E16655_01/server.121/e17909/prep_rep.htm
https://community.oracle.com/message/3746014
https://community.oracle.com/message/10035249
https://community.oracle.com/message/2560414
https://community.oracle.com/message/4333621
https://community.oracle.com/message/3259932
https://community.oracle.com/message/1290439
https://community.oracle.com/message/2182516
https://community.oracle.com/message/2100198
https://community.oracle.com/message/1894833
https://community.oracle.com/message/4245327
Browse all solutions to database errors from Oracle, MS SQL, or MySQL