ORA-04031: unable to allocate 4096 bytes of shared memory
help,thanks.
------解决方法--------------------------------------------------------
ORA-04031 unable to allocate string bytes of shared memory ("string","string","string","string")
Cause: More shared memory is needed than was allocated in the shared pool.
Action: 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.
一般的解决办法是增加DBMS_SHARED_ POOL但是具体情况还是要具体分析的你给的可参考条件太少所以不好说
------解决方法--------------------------------------------------------
要看是large pool还是shared pool的错误，就是ORA-04031 unable to allocate string bytes of shared memory ("string","string","string","string")
string部分
