Oracle DB Error ORA-04031 unable to allocate string bytes of shared memory ("string","string","string","string")

Oracle DB Error ORA-04031 unable to allocate string bytes of shared memory ("string","string","string","string")

The following is the cause of this error:

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

Action you can take to resolve this issue: 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 initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_ POOL_SIZE. If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE.


Tags: Database, Microsoft, SQL, Oracle, Software, DBMS




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution