Oracle Database Error Code ORA-4031 Description :
unable to allocate string bytes of shared memory (“string”,”string”,”string”,”string”)
Error Cause:
More shared memory is needed than was allocated in the shared pool.
How to Solve :
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”.
Search Oracle Error Codes and Descriptions:
Be The First To Comment
Similar Errors
Please Leave Your Comments Below