ora-04031 : unable to allocate 56bytes of shared memory("streams pool","unkown object","streams pool","fixed allocation callback")
several question.
1. when i restart db, can i solve it? naturally..
2. and.. oracle sr recommand i have to increase streams_pool_size to 32M.(it's correct?)
alter system set streams_pool_size=<new_value>M scope=spfile;
3.we don't use spfile. so in our init file, we dont have streams_pool_size. so, we add streams_pool_size in our init file?
or if we use <alter system set streams_pool_size=<new_value>M scope=spfile; >, we dont need streams_pool_size.?
thank you very much about your reading.