Thursday, September 18, 2008

ora-04031-unable to allocate 8196 bytes of shared memory


ORA-04031: unable to allocate string bytes of shared memory ("string" ,"string" ,"string" ,"string")


More shared memory is needed than was allocated in the shared pool.


If the shared pool is out of memory, either use the dbms_shared_pool package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the INIT.ORA parameters "shared_pool_reserved_size" and "shared_pool_size". If the large pool is out of memory, increase the INIT.ORA parameter "large_pool_size".
Post a Comment